Re: [ODBC] ODBC application works while libpq fails

Hi Igor,

On 2017/08/02 12:40, Igor Korot wrote:
> 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?

What is a query which causes a failure?
What is a result of locale command?

regards,
Hiroshi Inoue

>
> Thank you.
>
>
>> Thank you.