Search code examples
mysqlsqlheidisql

I can not add 'č' 'ř' 'ě'

I use HeidiSQL. I am unable add to my database characters with diacritics such as č, ř or ě.

For example, when I try add a character č, the following error occurs: 

Incorrect string value: '\xC4\x8D\' for column 'name' at row 1.

What I can do?

Column type is varchar. I think that this could be a problem with the coding, but I'm not sure.

Here's the coding of my database:

enter image description here

Solution

  • You are using UTF-8 and Latin-1 (which in MySQL is actually Windows-1252) in the same application. The first one is a fully Unicode compatible encoding but the second one can only store a very limited range of characters used in Western European languages. You simply cannot store Czech in the name column if it happens to use latin1_swedish_ci as url does.

    Create table

    We are in 2018. Use UTF-8 everywhere.