《MysqL应用如何查看MysqL编码与MysqL版本》要点:
本文介绍了MysqL应用如何查看MysqL编码与MysqL版本,希望对您有用。如果有疑问,可以联系我们。
导读:来看下面的sql语句,查看MysqL数据库的当前编码:MysqL> show variables like %set%;+--------------------------+-------------------...
来看下面的sql语句,查看MysqL数据库的当前编码:
MysqL> show variables like '%set%';
+--------------------------+------------------------------------+
| variable_name | value |
+--------------------------+------------------------------------+
| auto_increment_offset | 1 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /data/MysqL5/share/MysqL/charsets/ |
+--------------------------+------------------------------------+
9 rows in set (0.00 sec)
MysqL> s
--------------
./MysqL ver 14.12 distrib 5.0.22,for pc-linux-gnu (i686) using editline wrapper
connection id: 145
current database:
current user: root@localhost
ssl: not in use
current pager: stdout
using outfile: ''
using delimiter: ;
server version: 5.0.22-log
protocol version: 10
connection: localhost via unix socket
server characterset: latin1
db characterset: latin1
client characterset: latin1
conn. characterset: latin1
unix socket: /tmp/MysqL.sock
uptime: 2 days 20 hours 48 min 32 sec
threads: 2 questions: 728 slow queries: 0 opens: 0 flush tables: 2 open tables: 66 queries per second avg: 0.003
--------------
设置MysqL数据库编码,最简单办法:
set names utf8;
编程之家PHP培训学院每天发布《MysqL应用如何查看MysqL编码与MysqL版本》等实战技能,PHP、MysqL、LINUX、APP、JS,CSS全面培养人才。
总结
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您喜欢交流学习经验,点击链接加入交流1群:1065694478(已满)交流2群:163560250