Select from system tables gives weird output in Lazarus

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

marsupilami
Gold Boarder
Gold Boarder
Posts: 671
Joined: 17.01.2011, 14:17

Select from system tables gives weird output in Lazarus

Postby marsupilami » 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

seawolf
Zeos Dev Team *
Zeos Dev Team *
Posts: 385
Joined: 04.06.2008, 19:50
Contact:

Postby seawolf » 06.07.2011, 07:20

Hi, can you provide an example?
I mean
- the field type
- the field content

Thanks

marsupilami
Gold Boarder
Gold Boarder
Posts: 671
Joined: 17.01.2011, 14:17

Postby marsupilami » 22.07.2011, 15:54

Hello seawolf,

the problem seems to be gone - most probably due to an update of Lazarus...
Thanks for your help,

Jan


Return to “Firebird”

Who is online

Users browsing this forum: No registered users and 1 guest