Re: Need a way to configure encoding

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
>>>>
>>>