Change MySql Database character set
来源:互联网 发布:创业软件上海分公司 编辑:程序博客网 时间:2024/05/16 09:42
Change MySql Database character set:
mysql user/password: root/root
Update my.ini
default-character-set = utf8 -->> [client]
character_set_server = utf8 -->> [mysqld]
Check mysql character set:
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.02 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
- Change MySql Database character set
- Change system wide character set
- PL/SQL database character set
- mysql character set , collation
- Change MySQL default character set to UTF-8 in my.cnf?
- alter database hive character set latin1
- mysql set name、set character set区别
- PL/SQL database character set(AL32UTF8) and Client character......
- comment set character in mysql
- Unknown character set: 'utf8mb4' / mysql
- mysql字符集(character set)
- PL/SQL Database character set (WE8ISO8859P1) and Client character set (UTF8) are different
- PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- PL/SQL错误提示 database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- C#用异步BackgroundWorker执行一个文本读取的操作
- Spring中的设计模式-适配器模式
- android安卓创建快捷方式
- mysql导入导出.sql文件备份还原数据库
- byte[]数组和int之间的转换
- Change MySql Database character set
- hdu4310
- Import testcase database
- Android中Failed to 。。。。。。timeout错误的解决方法
- Apaceh config 虚拟主机步骤
- sql语句的优化
- FrameBuffer中获取Android屏幕截图
- android平台获取手机IMSI,IMEI ,序列号,和 手机号的方法
- File/Directory Permission in Unix/Linux