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