From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
---|---|
To: | Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Need a way to configure encoding |
Date: | 2024-08-13 18:32:38 |
Message-ID: | CADK3HHJaPTWrLqJObezPr7d022ABNFLTQ4TdEWss9W94K9xr9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Abhishek,
Unfortunately, no not without considerable work in the driver.
Dave Cramer
www.postgres.rocks
On Tue, 13 Aug 2024 at 10:50, Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
wrote:
> Yes. I am indeed using the Unicode version of the driver. I am constrained
> to use it. Is there a possibility where we can configure something to get
> SQL_VARCHAR instead of SQL_WVARCHAR for varchar column in the UNICODE
> driver?
>
> Regards,
> Abhishek Kumar
>
> On Tue, 13 Aug 2024 at 4:10 PM, Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
>
>> 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
>>>>
>>>
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Raiford | 2024-08-13 19:01:11 | Re: Need a way to configure encoding |
Previous Message | Dave Cramer | 2024-08-13 10:40:15 | Re: Need a way to configure encoding |