Select from system tables gives weird output in Lazarus
Posted: 05.07.2011, 17:09
Hello,
I try to read the Firebird system tables to be able to copy the structure of an existing database. In Delphi 6 everything works as expected. But in Lazarus I get an exception "Cannot transliterate character between character sets." It does not matter wether I set the codepage to UTF8 or WIN1252 in the connection properties. The problem seems to arise from a Field that contains the €-Sign.
On other system tables I can select but the output seems to be malformed. But not on every ocassion. So selecting the RDB$FIELD_NAME from RDB$FIELDS gives correct results whereas selecting RDB$CHARACTER_SET_NAME from RDB$DATABASE only gives garbage.
In Delphi 6 all this works correctly.
Anybody any ideas?
OS: Win 7 32-Bit
Firebird version: 2.1
FPC version: 2.2.4
Lazarus version: trunk
Zeos Version: svn://zeos.firmos.at/zeos/branches/6.6-patches REV. 903
Best regards,
Jan
I try to read the Firebird system tables to be able to copy the structure of an existing database. In Delphi 6 everything works as expected. But in Lazarus I get an exception "Cannot transliterate character between character sets." It does not matter wether I set the codepage to UTF8 or WIN1252 in the connection properties. The problem seems to arise from a Field that contains the €-Sign.
On other system tables I can select but the output seems to be malformed. But not on every ocassion. So selecting the RDB$FIELD_NAME from RDB$FIELDS gives correct results whereas selecting RDB$CHARACTER_SET_NAME from RDB$DATABASE only gives garbage.
In Delphi 6 all this works correctly.
Anybody any ideas?
OS: Win 7 32-Bit
Firebird version: 2.1
FPC version: 2.2.4
Lazarus version: trunk
Zeos Version: svn://zeos.firmos.at/zeos/branches/6.6-patches REV. 903
Best regards,
Jan