I am trying to access a MSSQL 2005 database with ODBC. I am trying to display some chinese words and all I get is this:
http://www.visualcron.com/translation.php?id=8
I know that the characters are ok (they look ok when using ASP.NET). Any ideas?
ODBC + MSSQL + UTF8 = true?
Yes, stop using ODBC and just use the COM functions and ADO . ODBC is the protocol of last-resort - slow and clumsy and limited functionality.
mrdance wrote:I am trying to access a MSSQL 2005 database with ODBC. I am trying to display some chinese words and all I get is this:
http://www.visualcron.com/translation.php?id=8
I know that the characters are ok (they look ok when using ASP.NET). Any ideas?
Or try my freshly minted OLE-DB extension. It does conversion to UTF-8. You can download it here: http://sourceforge.net/project/showfiles.php?group_id=171247&package_id=198554.
It was built mainly for SQL Server so it's been tested fairly extensibly for this purpose.
ODBC is very slow for some reason. In my own tests accessing the same database through it could be up to an order of magnitude slower.