2009-08-11 08:13:10 UTC
Hi,
I'm having problems inserting scandinavian special characters æ, ä, ø, ö and å into a table. I tried with both nvarchar(50) and varchar(50) but neither works.
Sqsh is run from Ubuntu 9.04 server with da_DK.utf8, da_DK/da_DK.ISO-8859-1 locales installed, and the default character set is UTF8.
I ran the following command from bash
# sqsh -Jlatin1 -b -Sdbserver -Ddbname -Udbuser -Pdbpass -C "insert into xfer_log (xferid,logtext) values (1, 'æøåÆØÅ')"
# sqsh -JANSI -b -Sdbserver -Ddbname -Udbuser -Pdbpass -C "insert into xfer_log (xferid,logtext) values (2, 'æøåÆØÅ')"
# sqsh -JISO-8859-1 -b -Sdbserver -Ddbname -Udbuser -Pdbpass -C "insert into xfer_log (xferid,logtext) values (3, 'æøåÆØÅ')"
The records in the DB table shows the familiar characters of a unicode characters inserted into a latin1 database or file æøåÆØÅ
What should I do?
