Re: Need a way to configure encoding

From: Dave Cramer <davecramer(at)postgres(dot)rocks>
To: Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
Cc: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: Need a way to configure encoding
Date: 2024-08-13 10:40:15
Message-ID: CADK3HHKuvtH+cFGVr4bEhpoTSjbEAza-im_R9GDGoaGJ1ddx1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Greetings,

I think you are using the unicode version of the driver. If you use the
non-unicode version it will use the locale settings and strings will be
returned as SQL_VARCHAR.

Dave Cramer
www.postgres.rocks

On Tue, 13 Aug 2024 at 05:05, Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
wrote:

> Can someone please help me answer this question?
>
> Regards,
> Abhishek Kumar
>
> On Tue, Aug 6, 2024 at 3:01 PM Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
> wrote:
>
>> Hi,
>>
>> I am working on a linux ODBC C++ application and using psqlodbc driver. I
>> need help on the below few questions.
>>
>> 1. Is there a way in which we can make the psqlodbc code work according
>> to the client encoding?
>> For example, if my application encoding is UTF-8, i would want the types
>> and strings returned to my application in UTF-8. I think by default, it is
>> returning UTF-16 strings.
>>
>> 2. The default behaviour of the driver is when we have a VARCHAR column
>> in a table, it returns SQL_WVARCHAR as the type. Is there a possibility
>> where we can configure something (maybe at connection string), such that it
>> returns SQL_VARCHAR for VARCHAR column and not SQL_WVARCHAR ?
>>
>> Please help me in answering the above questions.
>>
>> Regards,
>> Abhishek Kumar
>>
>

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Cramer 2024-08-13 18:32:38 Re: Need a way to configure encoding
Previous Message Abhishek Kumar 2024-08-13 09:05:03 Re: Need a way to configure encoding