dbExpress, MSSQL, UTF8

arrigo · Post by **arrigo** » Mon 28 Nov 2005 08:38

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.

Ikar · Post by **Ikar** » Mon 28 Nov 2005 11:00

You should execute "SET NAMES utf8" statement after connecting and convert all data manually.

arrigo · Post by **arrigo** » Tue 29 Nov 2005 01:40

But "SET NAMES" is available to MySQL only.

arrigo · Post by **arrigo** » Tue 29 Nov 2005 03:52

It seems that MS SQL is unable to return in UTF-8 encoding.
http://support.microsoft.com/kb/232580/EN-US
Too bad.

Ikar · Post by **Ikar** » Tue 29 Nov 2005 13:22

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.

arrigo · Post by **arrigo** » Wed 30 Nov 2005 01:32

Great to see that there is plan to support this.
Thank you!