From: | Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: Getting error : invalid string conversion occured. |
Date: | 2024-08-29 07:29:40 |
Message-ID: | CAAyULEChWEPUs0UW4JgWRx7JiAWM=ZvoN7+TSb82FvWdFNnR5w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Can someone please provide an answer to this question?
Regards,
Abhishek Kumar
On Fri, Aug 23, 2024 at 6:28 PM Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
wrote:
> Hi,
>
> I am using psqlodbc native driver with my C++ application. I am facing
> errors in the below scenario.
>
> I have a PostgreSQL database (Server character set is UTF-8, Database
> character set is UTF-8)
> My System character set/locale is ASCII. The session character set is also
> ASCII.
> Below is the details of the table i am using
> CREATE TABLE conv_vchar (
> id SERIAL PRIMARY KEY,
> vchar_col VARCHAR(255)
> );
>
> I am inserting some characters in table varchar column which is only
> available in UTF-8 and not in ASCII.
> The characters are "कखग".
> please note that none of these characters is present in ASCII.
>
> I have tried binding the varchar column with the below two types. Both
> give me the same error
> 1. SQL_C_BINARY
> 2. SQL_C_CHAR
>
> ODBC error: SQLSTATE S1000 native database error 36. invalid string
> conversion occured.
>
> Is there a correct way to bind this?
> How can this be fixed?
>
> Your help will be highly appreciated.
>
> Regards,
> Abhishek Kumar
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2024-08-29 10:26:52 | Re: Getting error : invalid string conversion occured. |
Previous Message | Abhishek Kumar | 2024-08-23 12:58:23 | Getting error : invalid string conversion occured. |