在MySQL中的字符集 [英] charset in MySQL
问题描述
我在MySQL开发一个博客,一切都将用英语,并将包含一些特殊字符像
I'm developing a blog in MySQL, everything will be in English and will contain some special characters like
`,〜, !@#$%^& *()_ + = - [] {};'\:|,。/ <>?/ * - +
`,~,!@#$%^&*()_+=-[]{};'\:"|,./<>?/*-+
Q1->我应该使用哪个字符集[和为什么]?
Q2-> UTF-8/16 / 32和Latin1?
Q3-> UTF-8使用的空间比那些空间少吗?
Q4->哪个字符集用于支持bengali?
Q1-> Which charset i should use [and why] ?
Q2-> what is the difference between UTF-8/16/32 and Latin1 ?
Q3-> Does UTF-8 uses less space than those ?
Q4-> Which charset to use to support bengali ?
[当我想保存在我的数据库中它转换为这是真的很无聊:x]
[When i want to save ' in my DB it convert it to ‘ which is really boring :x]
MySQL 5.5。 8和PHP 5.3.3
MySQL 5.5.8 and PHP 5.3.3
推荐答案
1:UTF-8,因为你关心的任何字符只需要一个字节,
1: UTF-8, since any character you care about will only take a single byte, plus it can be expanded if in the future you have characters not found in that.
2 + 3:绝对最低限度每个软件开发人员绝对,肯定地必须知道Unicode和字符集(无需借口!)
4:UTF-8。
这篇关于在MySQL中的字符集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!