Error character with byte sequency 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1252"
Posted: Tue 20 Oct 2020 20:48
Hello!
After converting the Firebird database to the Postgre database I came across the following error: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1252". This occurs in a field of type "bytea". For the display, I do the conversion as follows: CAST (substring (convert_from (CAST (psi.especificacao as bytea), 'latin1') from 1 for 100) AS VARCHAR (100))
It works perfectly in SQL_Manager or PgAdmim, but when the query is executed by the system, the error is presented with encoding. I use DBExpress with the CBuilder IDE.
Has anyone been through something like this?
Is there any way to configure the Devart driver so that it doesn't?
thankful
After converting the Firebird database to the Postgre database I came across the following error: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1252". This occurs in a field of type "bytea". For the display, I do the conversion as follows: CAST (substring (convert_from (CAST (psi.especificacao as bytea), 'latin1') from 1 for 100) AS VARCHAR (100))
It works perfectly in SQL_Manager or PgAdmim, but when the query is executed by the system, the error is presented with encoding. I use DBExpress with the CBuilder IDE.
Has anyone been through something like this?
Is there any way to configure the Devart driver so that it doesn't?
thankful