Mysql數(shù)據(jù)庫怎么查看使用的編碼

本篇內(nèi)容主要講解“MySQL數(shù)據(jù)庫怎么查看使用的編碼”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實(shí)用性強(qiáng)。下面就讓小編來帶大家學(xué)習(xí)“Mysql數(shù)據(jù)庫怎么查看使用的編碼”吧!

從事德陽電信服務(wù)器托管，服務(wù)器租用，云主機(jī)，雅安服務(wù)器托管，主機(jī)域名，CDN，網(wǎng)絡(luò)代維等服務(wù)。

Mysql數(shù)據(jù)庫默認(rèn)編碼

查看使用的編碼

1.  使用status查看

mysql> status

--------------
mysql  Ver 14.14 Distrib 5.6.44, for Linux (x86_64) using  EditLine wrapper

Connection id:      22
Current database:   
Current user:       root@localhost
SSL:            Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:    ;
Server version:     5.6.44 MySQL Community Server (GPL)
Protocol version:   10
Connection:     Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /var/run/mysqld/mysqld.sock
Uptime:         6 hours 31 min 31 sec

Threads: 1  Questions: 905  Slow queries: 1  Opens: 74  Flush tables: 1  Open tables: 67  Queries per second avg: 0.038
--------------

Server characterset:    latin1
Db     characterset:    latin1  (數(shù)據(jù)庫編碼格式)
Client characterset:    utf8        (客戶端連接進(jìn)來的編碼格式)
Conn.  characterset:    utf8        (接入的編碼格式)

2. 使用show variables

show variables like 'character'

mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

/etc/my.cnf文件中修改配置信息

  1. 使用默認(rèn)的配置信息

    • 本機(jī)訪問自己的數(shù)據(jù)庫:Server characterset:    latin1

      status

      Server characterset:   latin1
Db     characterset:   latin1
Client characterset:   utf8
Conn.  characterset:   utf8

      show variables like 'character%'

      +--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | utf8                       |

| character_set_connection | utf8                       |

| character_set_database   | latin1                     |

| character_set_filesystem | binary                     |

| character_set_results    | utf8                       |

| character_set_server     | latin1                     |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

      創(chuàng)建一個(gè)數(shù)據(jù)庫encodtest,查看其編碼信息

      Server characterset:   latin1
Db     characterset:   latin1
Client characterset:   utf8
Conn.  characterset:   utf8
      mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

      character_set_database是數(shù)據(jù)庫的編碼格式

      創(chuàng)建一個(gè)test表查看其默認(rèn)的編碼格式

      show create table test;

      +-------+-------------------------------
| Table | Create Table                                                                                               |
+-------+-------------------------------
| test  | CREATE TABLE `test` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-------------------------------

      DEFAULT CHARSET=latin1默認(rèn)的編碼格式是latin1,與數(shù)據(jù)庫編碼格式相同

  2. 更改配置文件/etc/my.cnf

    添加設(shè)置:

    [client]
default-character-set = utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_unicode_ci

    • 本機(jī)進(jìn)入數(shù)據(jù)庫

      查看編碼格式:

      status

      Server characterset:   utf8
Db     characterset:   utf8
Client characterset:   utf8
Conn.  characterset:   utf8

      show variables like 'char%';

      +--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+

      創(chuàng)建數(shù)據(jù)庫查看其編碼

      與上面相同

      創(chuàng)建表查看編碼:

      +-------+------------------------------------------------------
| Table | Create Table                                                                                                                     |
+-------+------------------------------------------------------
| test  | CREATE TABLE `test` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+-------+-----------------------------------------------------

      DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci默認(rèn)的編碼格式與配置相同

到此，相信大家對(duì)“Mysql數(shù)據(jù)庫怎么查看使用的編碼”有了更深的了解，不妨來實(shí)際操作一番吧！這里是創(chuàng)新互聯(lián)網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！

名稱欄目：Mysql數(shù)據(jù)庫怎么查看使用的編碼
分享路徑：http://muchs.cn/article12/ispjgc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供營銷型網(wǎng)站建設(shè)、Google、品牌網(wǎng)站設(shè)計(jì)、App開發(fā)、手機(jī)網(wǎng)站建設(shè)、企業(yè)網(wǎng)站制作

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)

成都定制網(wǎng)站建設(shè)