From: | "Andy Hallam" <ahm(at)exel(dot)co(dot)uk> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: ODBC SQLBindParameter and UNICODE strings |
Date: | 2001-10-19 08:02:01 |
Message-ID: | 9qomo5$1d6g$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Kindness | 2001-10-19 08:40:53 | Compiling on Solaris with Sun compiler |
Previous Message | Christof Petig | 2001-10-19 07:37:59 | Re: ecpg - GRANT bug |