Database using WIN1250 encoding is handled improperly

halmai posted 1 year ago in General

I have a legacy project that uses WIN1250 encoded postgres database. Both the Collate and the Ctype are "Hungarian_Hungary.1250".

In HeidiSQL, the Hungarian accents look weird. See the attachment. Could you fix this, please? Thanks.

1 attachment(s):
  • win1250
halmai posted 10 months ago

Here is a simple sample to create the postgres database and a value in a table:

createdb --encoding=WIN1250 --lc-collate=C --lc-ctype=C --template=template0 heidisql_1250

create table t (c text);

insert into t values (chr(193));

If you see the content in HeidiSQL then instead of the expected Hungarian accented a (รก), you will see a questionmark in a diamond shape, similarly to the formerly uploaded screenshot.

Could you fix this issue, please?

Please login to leave a reply, or register at first.