Why SQL error when insert turkish letter?

Question

I created a simple form with 3 inputs for make a new wedding.

I ask for name, password and email.

But if the user enters a Turkish letter like marvın, I get this error :

Erreur SQL (1366) : Incorrect string value: '\xC4\xB1n' for column 'name' at row 1

Someone can help me please? I'm lost ..

TY !

It seems that you are concatenating the values in the insert statement. If it is the case, then you shouldn't. You should declare an insert statement with parameters and send the values as parameter values. — MundoPeter, Sep 11 '20 at 22:49

score 0 · Answer 1 · edited Sep 12 '20 at 11:27

0

For the table column to accept any different letters than English I think it must have a collation so.

Alter table_name alter column names varchar(256) with collation Turkish..

edited Sep 12 '20 at 11:27

Vivek Jain

answered Sep 11 '20 at 17:26

George Mitsis

I try to change collation to 'latin5_turkish_ci' but nothing change always the same error.. – Marvin Dahlen Sep 11 '20 at 22:37

score 0 · Answer 2 · answered Sep 12 '20 at 11:32

0

Try using latin1_swedish_ci collation. I use this, it works for me.

answered Sep 12 '20 at 11:32

Pike Msonda

score 0 · Answer 3 · answered Sep 17 '20 at 13:05

0

I use Laragon, for change collation =

Right click > Maintenance > Change collation to latin5_turkish_ci

answered Sep 17 '20 at 13:05

Marvin Dahlen

3 Answers3