In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

MariaDB and german umlauts

Xailer English public forum
Timm
Posts: 105
Joined: Mon Jun 21, 2010 11:01 am

MariaDB and german umlauts

Postby Timm » Tue Jun 23, 2020 9:47 am

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
umlauts.png (6.35 KiB) Viewed 9845 times

What could be the reason for that?

Regards, Timm
User avatar
ignacio
Site Admin
Posts: 8685
Joined: Mon Apr 06, 2015 8:00 pm
Location: Madrid, Spain
Contact:

Re: MariaDB and german umlauts

Postby ignacio » Tue Jun 23, 2020 10:23 am

Hi Timm,

I suggest you change the Character set on all tables to 'latin1'. I hope it helps.

Regards,
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
http://www.xailer.com
Timm
Posts: 105
Joined: Mon Jun 21, 2010 11:01 am

Re: MariaDB and german umlauts

Postby Timm » Wed Jun 24, 2020 8:21 am

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
mariadb.png (8.18 KiB) Viewed 9831 times

Regards, Timm
User avatar
ignacio
Site Admin
Posts: 8685
Joined: Mon Apr 06, 2015 8:00 pm
Location: Madrid, Spain
Contact:

Re: MariaDB and german umlauts

Postby ignacio » Wed Jun 24, 2020 11:57 am

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,
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
http://www.xailer.com
Timm
Posts: 105
Joined: Mon Jun 21, 2010 11:01 am

Re: MariaDB and german umlauts

Postby Timm » Wed Jun 24, 2020 7:10 pm

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
User avatar
ignacio
Site Admin
Posts: 8685
Joined: Mon Apr 06, 2015 8:00 pm
Location: Madrid, Spain
Contact:

Re: MariaDB and german umlauts

Postby ignacio » Wed Jun 24, 2020 7:13 pm

Timm wrote: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,
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
http://www.xailer.com

Return to “English”