Re: ODBC SQLBindParameter and UNICODE strings

Thanks for that.

I'll have to work around this by extracting all character variable data and
'hard coding' this into the SQL statement before I SQLExecute() the
statement. I had to do the same for ... Oracle (sorry for swearing).

Do you (or anyone else for that matter) know if/when UNICODE binding will be
implemented in the Psqlodbc driver?

Andy.

building the character data into the SQL statement for
"Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> wrote in message
news:3BCF9A80(dot)F6DEF77C(at)tpf(dot)co(dot)jp(dot)(dot)(dot)
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)