CODEWITHSUNDEEP
phpmysqlunicode
Caravansary
Caravansary

Reputation: 81

Unicode Characters with Mysql

I have set my Charset "utf8 turkish ci" in my MySql database. Because I will store some Turkish characters in my project. I can properly enter Turkish charaters and see them. But my problem is that:

For example, i define "username" as varhar(20) and the maxlenght of inputbox is 20. That means user can't write any username more than 20 characters. But when user uses Turkish unicode characters (like ş,i,ü,ğ) there becomes "Data too long for column 'username'" error, because unicode characters are 2 bytes long!

I tried to update my database with phpmyadmin. But updating the lenght, brings some more errors. so do i have to drop all the tables and write them with x2 lenght? (i mean if data will be 20 char, that i define it varchar(40) ) I have 30 tables and it is a nightmare. Is there any way that i can do?

Upvotes: 0

Views: 1472

Answers (2)

Rick James
Rick James

Reputation: 142208

I suspect your <form> needs to include the charset: <form accept-charset="UTF-8">

Upvotes: 1

Evert
Evert

Reputation: 99505

MySQL will by default use 3 bytes to store any character for a VARCHAR specified as UTF8 (or 4 bytes for UTF8MB4).

VARCHAR(10) actually does mean 10 characters, 30 bytes. It doesn't mean 10 bytes.

Upvotes: 1

Related Questions