Re: ODBC SQLBindParameter and UNICODE strings

Andy Hallam wrote:
>
> Apologies if you think this mail is a little long-winded but I want to be as
> clear as possible on this.
>
> PostgreSQL - 7.1.3 (installed on Linux 2.4.2-2)
> PSQLODBC.DLL - 07.01.0007
> Visual C++ - 6.0
>
> I have a C++ app running on WINDOWS2000 and I am trying to use
> SQLBindParamater with a unicode (wchar_t) variable.
>
> I installed postgreSQL using the following arguments:
>
> ./configure --enable-multibyte=UNICODE --enable-unicode-conversion --enable-
> odbc
>

[snip]

>
> As you can see I can succesfully use an ASCII character string for an INPUT
> parameter when binding but not a UNICODE character string.
> Surely PostgreSQL supports binding of UNICODE character strings ?

Unfortunately no. Psqlodbc driver doesn't support UNICODE(UCS-2)
binding currently. --enable-multibyte=UNICODE means the sever side
support of UTF-8(not UCS-2) encoding.

regards,
Hiroshi Inoue