计算MySQL数据库的Unicode字符数

Question

When, in PHP, I have variable that's hold Unicode characters do I need to worry about storing it in MySQL database?

Lets say I have variable value Dejan Čolić, I suppose that will for Unicode characters use 2 chars (or 4, I am not sure). Then my variable will be 13/17 chars long in database instead of 11 chars that are firstly specified. Am I right?

If I am right, is there some PHP function that will help count future Unicode characters so I could do proper data validation? Thanks.

Answer 1

Characters are characters. 11 characters are 11 characters regardless of the environment. If MySQL doesn't know you are giving it UTF-8 encoded data, it may misinterpret the bytes and derive a different character count based on the assumption of a wrong encoding. But if MySQL is made aware of the correct encoding, it'll be 11 characters.

It'll be more bytes than that though, and even more bytes in MySQL since MySQL is storing UTF-8 data rather inefficiently.