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