Mysql encoding problems and Androidiphone_MySQL

Mysql encoding and Androidiphone Android

I encountered this problem when I was working on Android apps. I always wanted to talk about encoding.

Let's talk about how mysql supports Chinese. First, enter status under the mysql command line. Check the encoding. in linux, it is relatively simple. in my. cnf under etc/mysql, this is available on the Internet, so I won't talk about it.

Below xp is the most confusing place. Mysql in xp is latin1 by default. Similarly, you can modify my. ini. Or you can directly change the instance config in mysql5.0 or above. There is a problem to be aware of. in xp command line, only gbk Chinese characters can be identified, so utf8 cannot be identified. don't think you see garbled characters, but it is normal in the browser.

Then, in the browser, Sogou's browser does not know what bird code is supported. it is garbled when sent to mysql, but chrome is normal. The tangle of problems has not been solved so far. The iphone is certainly not utf8, because I did not know what encoding I found when I was working on the iphone, which is said to be utf16...

Green channel: please follow my favorites to contact me