[Resolved] Problem with special characters used by Czech language

More
1 year 1 month ago - 1 year 1 month ago #19645 by mcLoad
I cannot insert and save some special characters that are used in the Czech language.

To replicate this issue: login to administration, go to Components -> Solidres -> Properties
Create property and insert this to Address 1 line - "Kovářova 214" or try to insert this to City line - "Žďár nad Sázavou"

It ends with this error message: "Save failed with the following error: Incorrect string value: '\xC5\x99ova ...' for column 'address_1' at row 1"

also same problem is in Currencies

Create new Currency with this setting - Name: CZK , Code: CZK , Symbol: Kč
It ends with this error message: "Save failed with the following error: Incorrect string value: '\xC4\x8D' for column 'sign' at row 1"

Can you help me fix this?
Last edit: 1 year 1 month ago by mcLoad.

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #19647 by solidres
Hi,

This is not a Solidres issue, you should check your database and make sure Solidres tables are using Unicode encoding, if not you should fix it. You can use an extension called Admin Tools which can change tables collation.

Regards,
The following user(s) said Thank You: mcLoad

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #19649 by mcLoad
Thank you for help, its working now!

Please Log in or Create an account to join the conversation.

Moderators: solidres
Powered by Kunena Forum

All the things you need to make your work easier. Did you like Solidres?