Page 1 of 1
dbExpress, MSSQL, UTF8
Posted: Mon 28 Nov 2005 08:38
by arrigo
I would like to know how to set Params in TSQLConnection of dbExpress
to configure MSSQL to return nvarchar columns in UTF-8.
Thank you very much.
Posted: Mon 28 Nov 2005 11:00
by Ikar
You should execute "SET NAMES utf8" statement after connecting and convert all data manually.
Posted: Tue 29 Nov 2005 01:40
by arrigo
But "SET NAMES" is available to MySQL only.
Posted: Tue 29 Nov 2005 03:52
by arrigo
It seems that MS SQL is unable to return in UTF-8 encoding.
http://support.microsoft.com/kb/232580/EN-US
Too bad.
Posted: Tue 29 Nov 2005 13:22
by Ikar
You are right, it's MySQL command. We have UTF-8 support in plans, but it's quite difficult task and we can't specify a date.
Posted: Wed 30 Nov 2005 01:32
by arrigo
Great to see that there is plan to support this.
Thank you!