Latest version from SVN and Firebird and åäö on ISO8859_1

frla · Post by **frla** » 11.10.2011, 19:27

I am using standard Delphi controls and storing åäö results in weird character when I read them from the database again. I can imagine that it saves my characters as Unicode but reading them back normally which results in weird characters (even though åäö is weird characters to some...

).

How can I solve it? I have tried different settings but it only seem to apply for MySQL but I am using Firebird and a ISO8859_1-database with data in it...

Help plz...

marsupilami · Post by **marsupilami** » 12.10.2011, 12:34

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

frla · Post by **frla** » 14.10.2011, 19:27

No, I didn't see the codepage-parameter but I tried to set it but nothing happened.. I assume you mean something like CODEPAGE=ISO8859_1? I am using Delphi XE. I recompiled the project in Delphi 5 with Zeos 6.6 where it works.

marsupilami · Post by **marsupilami** » 18.10.2011, 09:34

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 "Properties"-Property of your TZConnection-Object.
This tells firebird to translate between your database character set and Unicode. Please let me know if this helps you.
Best regards,

Jan

frla · Post by **frla** » 18.10.2011, 19:16

Hmm.. it works if I use a DBMemo but when I use Developer Express controls (Grid + their DBMemo) it doesn't work. Do they send the text to the table in a different format perhaps?

I tried with standard dbedit earlier so the patch seems to fix something...

marsupilami · Post by **marsupilami** » 19.10.2011, 13:16

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.

Post by **EgonHugeist** » 08.02.2012, 09:42

frla,

there is an additional testing-branch on Sourceforge called testing-egonhugeist. Can you please test my modifications and tell me what happens to you DBExpress-Memo components? marsupilami's patch fixes many problems but actually there was a mess of Unicode-Blob fields which you are usings for your Memo's or am i wrong. Can you please do some Bugreports? There it should be possible to use your favorite CharacterSet..

regards EgonHugeist..