| From: | "Csaba" <cs(dot)smela(at)medical-tribune(dot)hu> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | 'Key violation' error |
| Date: | 2005-08-11 22:02:33 |
| Message-ID: | 000801c59ec0$61b7c4b0$640aa8c0@csabahomeibm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bobby Brewster | 2005-08-12 02:51:26 | HELP: Unrecognized key passed to SQLGetInfo30(#209) |
| Previous Message | Hans-Jürgen Schönig | 2005-08-11 20:08:46 | troubles with configure script on solaris ... |