Re: Getting error : invalid string conversion occured.

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
>