手動update或寫入字段中文數(shù)據(jù)亂碼解決?￡?é?”????–1????￥?è???–°?

2024-06-03 19:19| 來源: 網(wǎng)絡整理| 查看: 265

比如我本地服務器端數(shù)據(jù)庫更新或寫入中文，在數(shù)據(jù)庫查看正常，但是在vue前端則打印 ?￡?é?”????–1????￥?è???–°?— ，這啥玩意兒~

定位到數(shù)據(jù)庫編碼問題

雖然在服務器端可以顯示中文正常，在本地數(shù)據(jù)庫服務端也顯示正常，但是在客戶端可能會顯示亂碼。因為我們的服務器是UTF8，這里就需要查看下數(shù)據(jù)庫編碼的問題了。如下作

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

在這里插入圖片描述

解決辦法相同

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

【本文地址】

公司簡介

聯(lián)系我們

今日新聞

推薦新聞

專題文章