
9 Jun
2009
9 Jun
'09
1:23 p.m.
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? Thank you in advance. Sebastian