Zeoslib Portal

Hello Onis, in my programs I do something like this to try to load the firebird client library before zeos tries to do it: var LibraryHandle: THandle; procedure preloadLibrary(LibName: String); begin if LibraryHandle <> 0 then FreeLibrary(LibraryHandle); if (LibName <> '') and (FileExists(LibName)) ...

Hello pawelp, is WIN1252 really the correct codepage for you to use? I just ask because your profile states that you live in poland and Wikipedia says that the codepage, which is used in poland, should be WIN1250. I don't use postgres, so I don't know if it is possible to do anything about these err...

Hello Onis,

another way might be to load the library yourself before zeos tries to load it. I do that for the firebird client library in some of my programs.
Best regards,

Jan

Hello pawelp, it seems that you use an ANSI-Version of Delphi. Maybe you should ask Postgres to do the conversion between your codepage (1250?) and UTF8? Unfortunately I don't know how to do that. Maybe something like ZConn.Properties.Values['codepage']:='WIN1250'; or ZConn.Properties.Values['client...

Hello Douglas, the current firebird driver of Zeos has problems when it comes to characer sets. I currently try to fix this. You can find the current version of a patch that tries to fix this here: http://zeos.firmos.at/viewtopic.php?p=14111#14111 If you try to use that patch, it is best to set CODE...

Hello Michael,

this is the second version of the patch. Strings should now be converted correctly. Maybe you can take a look at it? I did not look into the correct translation of blob fields yet.
Also I have no idea how to do a comprehensive test. Maybe you have an idea?
Best regards,

Jan

Hello Michael, hmmm - for the start I would try to implement a consistent handling of Stringfields. Use (Ansi)StringField when you have an ansi codepage and use WideStringField when it is a Unicode Connection. I think it is the responsibility of the application developer to select the right one. But...

Hello Michael, I am sorry that my answer is somewhat lengthy. But I see no other way how to say everything and be precise at the same time. We need a WideToAnsi-String translation here or we lost some String-Data. On executing UTF8Encode(AString) the result is Ansi-compatible. But the AnsiCodepage t...

Hello Michael, Your patch and all others (MySQL, PostgreSQL, SQLite-not yet) USE UTF8Encode/Decode as an StringToAnsi-Adapter. Actually, this isn't what is happening. The patch doesn't use UTF8Encode anywhere. I don't know how other database servers work. But with Firebird it is like this, if I unde...

Hello EgonHugeist, I attached the patch. Maybe it is not completely right. But it might go into the right direction as it solved unicode handling for the standard Delphi TDBEdit. It seems that it solved problems for one guy whereas another guy seemed to have problems with some controls (see http://z...

Hello boreas, mdaems and EgonHugeist, I am no expert at zeos. But shouldn't boreas use CODEPAGE=UTF8 in TZConnection.Properties when he uses a Delphi that uses Unicode? This way Firebird can do all the conversion that is needed and all that the lower levels of Zeos have to do is advertise the result...

Hmm - I only tested for the normal DBEdit and DBGrid. Can you explain in greater Detail what happens or make a small screenshot? I don't have the Developer Express controls, so I can't test with them.

Hello frla, I tried to make a patch that allows Delphi XE to access firebird databases and use Unicode. This patch might help you too. You can find it in the Thread http://zeos.firmos.at/viewtopic.php?p=13635#13635 . Please apply this Patch to Zeos 7 and add the line "CODEPAGE=UTF8" to the...

Hello StoRmtec, I had a similar problem with Delphi XE. The problem seems to be that windows can not find the ZComponentDesign160.bpl. Windows tries to load it as it would load a regular dll. So it has to be in the same directory as the Delphi executable or in the path environment variable. So you s...

Hello frla,

which version of Delphi do you use? Did you set the CODPAGE parameter in TZConnection? If yes to which value did you set it?
Best regards,

Jan