Getting error : invalid string conversion occured.

From: Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Getting error : invalid string conversion occured.
Date: 2024-08-23 12:58:23
Message-ID: CAAyULEDVAWounPX-RKuzDR42HRAMDaMRz0pSAp3mFH3BYKF2NQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Abhishek Kumar 2024-08-29 07:29:40 Re: Getting error : invalid string conversion occured.
Previous Message Dave Cramer 2024-08-23 10:56:12 Re: Need information on bind type for certain data types in PostgreSQL