Hi Sebastian, On Tue, Jun 09, 2009 at 03:23:34PM +0200, 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');
With the May2009 release on 64-bit Febora 10 using a UTF-8 shell, this works for me, once I fix the syntax of the insert statement: sql>CREATE TABLE Umlautnamelist(CUST_ID numeric(9,0) not null, CUST_NAME varchar(100) not null, constraint Umlautnamelist_PK primary key (CUST_ID)); 0 tuples sql>INSERT INTO Umlautnamelist (123456789,'Bräuer'); !syntax error, unexpected sqlINT in: "insert into umlautnamelist (123456789" 0 tuples sql>INSERT INTO Umlautnamelist values (123456789,'Bräuer'); Rows affected 1 sql>select * from Umlautnamelist; +------------+-----------+ | cust_id | cust_name | +============+===========+ | 123456789 | Bräuer | +------------+-----------+ 1 tuple sql>
Are there any chances to get it working?
Apparently yes ;-) Stefan
Thank you in advance.
Sebastian
------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |