Página 1 de 1
MariaDB and german umlauts
Publicado: Mar Jun 23, 2020 9:47 am
por Timm
Hi!
I have a problem with german umlauts.
On my developing pc the umlauts are shown correctly in the application and when I browse the data with HeidiSQL.
But on my customers side it is correct in HeidiSQL not in my application.
- umlauts.png (6.35 KiB) Visto 30854 veces
What could be the reason for that?
Regards, Timm
Re: MariaDB and german umlauts
Publicado: Mar Jun 23, 2020 10:23 am
por ignacio
Hi Timm,
I suggest you change the Character set on all tables to 'latin1'. I hope it helps.
Regards,
Re: MariaDB and german umlauts
Publicado: Mié Jun 24, 2020 8:21 am
por Timm
Hi Ignacio,
changing the character set to 'latin1' did not help.
When I try to save a field with an umlaut I get this error message:
- mariadb.png (8.17 KiB) Visto 30840 veces
Regards, Timm
Re: MariaDB and german umlauts
Publicado: Mié Jun 24, 2020 11:57 am
por ignacio
Hi,
Tested the word 'Störung' with a personal software and it worked nicely with character set latin1.
Be aware that character set can be set even at field level.
Regards,
Re: MariaDB and german umlauts
Publicado: Mié Jun 24, 2020 7:10 pm
por Timm
Hi Ignacio,
finally I found the problem.
my.ini contained the row 'character-set-server=utf8'.
I deleted that line and now it works.
I would like to encourage everbody to use MariaDB!
Very powerful and I am asking myself why I have stuck with dbf for so long.
The Xailer team did a great work with the integration. Many, many thanks!
Regards, Timm
Re: MariaDB and german umlauts
Publicado: Mié Jun 24, 2020 7:13 pm
por ignacio
Timm escribió:Hi Ignacio,
finally I found the problem.
my.ini contained the row 'character-set-server=utf8'.
I deleted that line and now it works.
I would like to encourage everbody to use MariaDB!
Very powerful and I am asking myself why I have stuck with dbf for so long.
The Xailer team did a great work with the integration. Many, many thanks!
Regards, Timm
Glad you found the problem an thanks for your confidence. I couldn't agree more.
Regards,