[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