Database encoding

[Lufa]

Hi all.

I have a problem with Cyrillic symbols in Events name.

Everything looks fine in Zabbix fronted. All Cyrillic characters displaying correctly.

But all messages which comes to Jabber or emails are displaying like:

Модем 126 недоступний: OFF

instead of Ukrainian "Модем 126 недоступний: OFF".

I have checked database tables of Zabbix. despired my tables are in UTF-8 charset I can not see normal characters there too, only some "Модем".

Using charset "autodecoding" program I have found that database Cyrillic should be converted from CP1252 to UTF-8 to be displayed correctly.

Where is it come from? I am using English GUI locale, my web pages are in UTF-8 when entering the text.

It is not so annoying, because there are no problems in GUI, but it is impossible to read received events description.

Any advice? Thank you!

P.S.
Zabbix 1.5.4b (from 26.08.08), FreeBSD 7.0,
Database tables: InnoDB, utf8_unicode_ci
MySQl cersion: 5.0.51a
MySQL server Charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf_unicode_ci

[Aly]

Try this patch, but probably you'll need to reenter names for triggers.

P.S. Keep in mind that only zabbix frontend was made unicode ready, none DB or server are. So it's not well tested. You are doing this on your on risk!

[Lufa]

Try this patch, but probably you'll need to reenter names for triggers.

P.S. Keep in mind that only Zabbix frontend was made unicode ready, none DB or server are. So it's not well tested. You are doing this on your on risk!

Great!

I made a database backup, "converted tables from UTF-8 to CP1252 (1252? Once more - have no idea where did it came from. BTW not from CP to UTF, but exactly from UTF to CP!). And than, my data became "readable" UTF-8 text, so I can freely read it in text editors on my Ubuntu desktop.

Than I restored mysql dump ("reconverted" to UTF-8 as describe above) an applied the Patch, an WOW, now it is visibly good as before, but all events sent to Jabber or Email are readable as well, in Ukrainian Cyrillic!

It seems there is some problem with default email charset, but I will check it later.

Thank you very much!!! I hope this will be included in future releases.
Great job!

[NOB]

Great!

... some text removed ...

It seems there is some problem with default email charset, but I will check it later.

Thank you very much!!! I hope this will be included in future releases.
Great job!

Did you see this patch for the E-Mail header/charset ?

HTH.

Regards

Norbert.

[Lufa]

Did you see this patch for the E-Mail header/charset ?

HTH.

Regards

Norbert.

Yes, I did. But I thought it is already applied.

Thank you!

[Aly]

BTW if you don't want to convert DB to utf8, you can try to apply this patch: