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.
What could be the reason for that?
Regards, Timm
MariaDB and german umlauts
- ignacio
- Site Admin
- Mensajes: 9255
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
Re: MariaDB and german umlauts
Hi Timm,
I suggest you change the Character set on all tables to 'latin1'. I hope it helps.
Regards,
I suggest you change the Character set on all tables to 'latin1'. I hope it helps.
Regards,
Re: MariaDB and german umlauts
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:
Regards, Timm
changing the character set to 'latin1' did not help.
When I try to save a field with an umlaut I get this error message:
Regards, Timm
- ignacio
- Site Admin
- Mensajes: 9255
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
Re: MariaDB and german umlauts
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,
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
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
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
- ignacio
- Site Admin
- Mensajes: 9255
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
Re: MariaDB and german umlauts
Glad you found the problem an thanks for your confidence. I couldn't agree more.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
Regards,