Mysql ignores encoding "koi8u_general_ci"

user_15575310 0
Viewed 33

It is 100% this encoding

Problem while inserting

Somewhere saw that it can be problem with 'root' user, but I use other one. This encoding has to be for Ukrainian language (i have changed table encoding) but while inserting Ukrainian text, it shows me a problem. I havent found what to do, pls help me. I use mysql.

Ah and my table is it is

mysql sql
1 Answers

Found answer:

I tried to change encoding this way: (doesnt work)

ALTER TABLE `questions` COLLATE koi8u_general_ci;

But I had to do it this way:

ALTER TABLE table_name CONVERT TO CHARACTER SET koi8u COLLATE koi8u_general_ci;

so it works))

user_155753100
Related