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...
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.
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,
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...
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.
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..