Wrong message on error
Posted: 03.02.2015, 14:33
Hello,
I'm using Zeos 7.1.4 stable with Delphi XE 7 and Postgres 9.4; when there is an error (SQL-Syntax or other), I always get ' "SQL Error: ERROR: character with byte sequence ... in encoding "UTF8" has no equivalent in encoding "LATIN1" '.
The message is generated by "TZPostgreSQLBaseDriver.GetErrorMessage", which (as far as I understand) calls "PQerrorMessage" from the Postrges-library.
The same SQL-statement in "pgAdmin" generates (for example) "Syntaxerror at WHERE, Line ..."
Maybe I'm doing something wrong - any help would be helpfull !
Thanks
Andreas
I'm using Zeos 7.1.4 stable with Delphi XE 7 and Postgres 9.4; when there is an error (SQL-Syntax or other), I always get ' "SQL Error: ERROR: character with byte sequence ... in encoding "UTF8" has no equivalent in encoding "LATIN1" '.
The message is generated by "TZPostgreSQLBaseDriver.GetErrorMessage", which (as far as I understand) calls "PQerrorMessage" from the Postrges-library.
The same SQL-statement in "pgAdmin" generates (for example) "Syntaxerror at WHERE, Line ..."
Maybe I'm doing something wrong - any help would be helpfull !
Thanks
Andreas