比如我本地服務器端資料庫更新或寫入中文，在資料庫查看正常，但是在vue前端則列印 ?￡?é?”????–1????￥?è???–°?— ，這啥玩意兒~
定位到資料庫編碼問題
雖然在服務器端可以顯示中文正常，在本地資料庫服務端也顯示正常，但是在客戶端可能會顯示亂碼，因為我們的服務器是UTF8，這里就需要查看下資料庫編碼的問題了，如下操作
show variables like '%char%';
> set character_set_server=utf8;
Query OK, 0 rows affected (0.01 sec)
> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)
> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
> 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 |
+--------------------------+--------+
資料庫中文顯示 ？？？？
> show variables like "char%";
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.01 sec)
解決辦法相同
> set character_set_server=utf8;
Query OK, 0 rows affected (0.01 sec)
> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)
> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
> 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 |
+--------------------------+--------+
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/4381.html
標籤：區塊鏈
上一篇：物聯網為什么需要5G？