Thread: 'Key violation' error

'Key violation' error

From
"Csaba"
Date:
Driver version: 08_00_0100, 08_00_0101, 08_00_0102
Database version: 8.03 (Both Windows and Linux )
Encoding : LATIN2 ; collation : hu_HU
 
 
App. written in Delphi 7.
Recently upgraded PostgresqglODBC to 08_00 from 07_03_200.
 
Since then if any varchar field of a dataset (TTable or TQuery) containes non-ASCII chars (hungarian letters) trying to post raises DBEngineErrorr exception with following message: 'Key violation, ERROR: syntax error at or near ""XXX" at character Y'
 
"XXX" is the ASCII part of the sting while "Y" is a number which value depends on where the first non-ASCII character is located in the string.
 
You can post strings with pure ASCII chars.  
 
 07_03_200 and all earlier works perfect.