Thank you for your interest in MonetDB. Sebastian Bräuer wrote:
Hallo everybody, I would like to know whether there exist any possibilities to add tuples with umlauts as characters (ä,ö,ü) or other special characters like ß to tables.
I tried to use the regular INSERT-statement as well as the COPY INTO-statement with a csv input file but without success (unexpected end of input error or missing ' to close the string).
Example: CREATE TABLE Umlautnamelist(CUST_ID numeric(9,0) not null, CUST_NAME varchar(100) not null, constraint Umlautnamelist_PK primary key (CUST_ID));
INSERT INTO Umlautnamelist (123456789,'Bräuer');
Are there any chances to get it working?
MonetDB is fully capable of dealing with accented characters, but it will only work with the UTF-8 encoding. If your data is in a UTF-8 encoded file, you can load it in using the COPY INTO query. If you are using mclient, then you may have to tell it (i.e. mclient) which character encoding it should use so that it can translate to and from UTF-8 when communicating with the server. For that there is the -E<encoding> flag, e.g. mclient -lsql -Eiso-8859-1 Usually mclient is able to determine the correct encoding from the environment, but it may be necessary to give it a hand. If mclient is using the correct encoding, your query should work. -- Sjoerd Mullender