Re: Getting error : invalid string conversion occured. - Mailing list 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.aak0@gmail.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