Hungarian characters in Firebird database

2
votes

I cannot seem to get Hungarian accented characters to store properly in my Firebird database despite using ISO8859_2 character set and ISO_HUN collation.

This string for example:

Magyar Képzőművészeti Egyetem, Festő szak, mester: Klimó Károly

gets displayed as

Magyar Képzomuvészeti Egyetem, Festo szak, mester: Klimo Karoly

What am I doing wrong?

1
firebirdfirebird2.1
It's a bit weird that ó and á are stripped as well: those should be in latin1 as well (to which latin2 usually falls back) - Andras Deak
You need to provide more information: what is your connection character set, what is the column character set, how are you getting and storing the data, and how are you retrieving and displaying the data? - Mark Rotteveel
Connection is ISO8859_2 as is column character set. I am just using IBEXPERT. - Jonathan Hyams
Interesting, what happens if you do something like select 'Képzőművészeti' from RDB$DATABASE - Mark Rotteveel

1 Answers

0
votes

Your string is UTF8 encoded. It's working fine with IBExpert and an UTF8 database. Make sure that you're using the correct character set (DB connection, DB column, string).