{"id":406,"date":"2011-06-12T16:44:55","date_gmt":"2011-06-13T02:44:55","guid":{"rendered":"http:\/\/mymonkeydo.com\/?p=406"},"modified":"2011-06-12T16:44:55","modified_gmt":"2011-06-13T02:44:55","slug":"mysql-utf-8","status":"publish","type":"post","link":"https:\/\/mymonkeydo.com\/mysql-utf-8\/","title":{"rendered":"MySQL UTF-8"},"content":{"rendered":"
I have a database that needs to\u00a0accommodate all languages. \u00a0Currently it is set to the default latin1_swedish_c1. \u00a0I’m thinking I need to change it to UTF8, but there are so many UTF8 encodings!<\/p>\n
<\/p>\n
“_cs” is for case sensitive\u00a0collations. \u00a0So for case insensitive applications you can use utf8_general_ci. \u00a0utf8_bin is binary so it’s case sensitive.<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[2],"tags":[51],"yoast_head":"\n