[erlang-questions] ODBC param query unicode

Ryan Huffman <>
Wed Feb 23 20:27:54 CET 2011


>
> should use mysql native driver, It works fine.


Unfortunately I'm using SQL Server and not MySQL, thank you for the
suggestion though.

It says add some unicode support!  (Some is an importante word here).


Hi Ingela,

Sorry, I should have worded my question better.  I was mostly interested in
finding out what the extent of the added support was :).

Thanks for the tip on the test cases.  Unfortunately I still haven't had any
luck.  The SELECTs still aren't returning unicode, just latin1 binaries. I'm
using Arch Linux, unixODBC and freeTDS.  Using wvarchar always fails with a
bind error - looking at the c code, it looks like a unixodbc or freetds
error.  At this point I'm about ready to throw the towel in.

Thanks for the help,

Ryan

On Wed, Feb 23, 2011 at 1:42 AM, Ingela Andin <>wrote:

> Hi!
>
> It says add some unicode support!  (Some is an importante word here).
> You have to
> handle the encoding yourself but you can insert and extract unicode
> data if you know
> how your datbase engine handles unicode data.
> See the test case unicode in odbc_data_type_SUITE.erl
>
> Regards Ingela Erlang/OTP team - Ericsson AB
>
> 2011/2/23 Ryan Huffman <>:
> > According to the release notes the 2.10.8 added unicode support, but thus
> > far I haven't had any luck getting it to work (
> >
> http://www3.erlang.org/documentation/doc-5.8/lib/odbc-2.10.8/doc/html/notes.html
> ).
> >  Can anyone shed some light on what is supported?  I've tried using
> > param_query's with sql_wvarchar but without success (using utf8, utf16
> > little endian, utf16 big endian, etc...), and selecting rows with utf
> > characters returns a ? in place of utf characters (as expected, the rest
> of
> > the characters are still 8 bits wide rather than 16).
> >
> > Using 2.10.8 and R14B, connecting to an MSSQL server.
> >
> > Thanks,
> >
> > Ryan
> >
>


More information about the erlang-questions mailing list