Skip site navigation (1) Skip section navigation (2)

Varchar parameter conversion

From: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Varchar parameter conversion
Date: 2007-07-23 13:43:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc


My client program is developed on C++ & ODBC.

It's a Windows Unicode application.


I'm trying to pass a "varchar" parameter value to a user-defined stored

Each character of this actual parameter value (which ASC code is greater
than 127) is transformed into some two chars.

This value is stored and bound as a non-Unicode string (traditional
C-string) in the program.

So, some conversion happens for these characters.

It seems to me that it's the ODBC driver's intervention.


Is that right?

And how can I avoid this unwanted conversion?


Additional environment info:


OS: Windows XP SP2

PostgreSQL version: "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by
GCC gcc.exe (GCC) 3.4.2 (mingw-special)"

ODBC driver version: PostgreSQL Unicode


SHOW server_encoding;



SHOW client_encoding;



Thank you.



pgsql-odbc by date

Next:From: Andrei KovalevskiDate: 2007-07-23 14:40:59
Subject: Re: Varchar parameter conversion
Previous:From: Jan MuszynskiDate: 2007-07-21 20:55:06
Subject: Re: Switching Between Databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group