Re: [ODBC] ODBC application works while libpq fails

Hi,

On Mon, Jul 31, 2017 at 9:05 AM, Igor Korot <ikorot01@gmail.com> wrote:
>  Hi,
> I have a very weird situation.
>
> I am trying to develop an application which will connect to the PostgreSQL
> server thru 2 different methods: thru the ODBC and using libpq.
>
> Environment:
> MacOSX 10.8.
> Xcode 4 (latest available for 10.8)
> PostgreSQL 9.1 - original from OSX.
> Application is compiled with the UNICODE
> iODBC DM for OSX 10.8.
> Both application and DB server running on the same machine.
> The database I'm using was created with the default parameters (just
> CREATE DATABASE draft).
>
> When I connect with the ODBC driver, the application works as expected
> - no errors or problems.
>
> However when I tried to run the application with libpq I received an
> error. The error is:
>
> [quote]
> Invalid byte sequence for encoding UTF-8 0xc3\n
> [/quote]
>
> The application is written in C++ (not ObjC++).
> The table I am trying to query contains the field with the word
> "abc+<ALT225>", which inside the database is translated as
> "abc\xc3\x9f".
>
> What could be the reason for such behavior?
>
> Is ODBC driver sets the client encoding to some uniform value?
> Or there something else?

Here is the content of my .odbc.ini for PostgreSQL on Mac:

[code]
[postgre]
Driver               = PostgreSQL Unicode Driver
host                 = localhost
ServerName           = localhost
SERVER               = localhost
PORT                 = 5432
UserName             = postgres
Password             = <my_passwd>
Database             = draft
UseServerSidePrepare = 1
[/code]

As you can see there is no special encoding settings. So it uses one
that is set by default.
But using ODBC API works and trying libpq - doesn't.

Could someone please help?

Thank you.


>
> Thank you.