[freetds] UTF-8 Support: how to bind char strings?
Sebastien FLAESCH
sf at 4js.com
Thu Jan 10 11:12:53 EST 2008
I will start to make some tests using the UTF-8 cgarset on the client side with NCHAR / NVARCHAR columns on the server side...
Is there any special consideration I should take into account?
From my understanding, if the client is in utf8, the binding the SQL Parameters and fetch buffers with
C type = SQL_C_CHAR or SQL_C_VARCHAR (utf8 is not wchar)
and passing the number of bytes (not characters) should be ok... right?
What about the SQL type to be specified?
Should I use:
SQL_WCHAR / SQL_WVARCHAR
or
SQL_CHAR / SQL_VARCHAR
Does it really matter?
Anyone with ODBC + UTF-8 experience using FreeTDS?
Thanks
Seb
More information about the FreeTDS
mailing list