【MySQL報錯】1366 - Incorrect string value: ‘\xE6\x80\xBB\xE7\xBB\x8F...‘ for column ‘name‘ at row 1
某天插入資料時出現報錯
出現這個錯誤的原因是,資料庫的編碼格式為latin1 而我要將utf8的中文插入到資料庫中。
解決辦法:
找到表中欄位
改變欄位的字元編碼
總結:
MySQL中預設字符集的設定有四級:伺服器級,資料庫級,表級 。最終是欄位級 的字符集設定。注意前三種均為預設設定,並不程式碼你的欄位最終會使用這個字符集設定。請將你的插入資料字元編碼和表中欄位編碼統一。
相關的sql命令
修改資料庫字符集:
ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];
把表預設的字符集和所有字元列(CHAR,VARCHAR,TEXT)改為新的字符集:
ALTER TABLE tbl_name CONVERT TO CHARACTER SET character_name [COLLATE ...]
如:ALTER TABLE logtest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
只是修改表的預設字符集:
ALTER TABLE tbl_name DEFAULT CHARACTER SET character_name [COLLATE...];
如:ALTER TABLE logtest DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
修改欄位的字符集:
ALTER TABLE tbl_name CHANGE c_name c_name CHARACTER SET character_name [COLLATE ...];
如:ALTER TABLE logtest CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
檢視資料庫編碼:
SHOW CREATE DATABASE db_name;
檢視錶編碼:
SHOW CREATE TABLE tbl_name;
檢視欄位編碼:
SHOW FULL COLUMNS FROM tbl_name;
Linux 系統下解決辦法:
參考
https://www.cnblogs.com/afeiiii/p/13220997.html
相關文章
- MySQL ERROR 1366(HY000):Incorrect string value:''for column''at row 1解決方案MySqlError
- mysql 報錯:ERROR 1366 (HY000): Incorrect string value: ‘\xD5\xC5\xC8\xFD‘ for column ‘name‘ at row 1MySqlError
- MySQL 亂碼實戰解決ERROR 1366 (HY000): Incorrect string value: 'MySqlError
- MySQL-修改表的編碼和列的編碼-Incorrect string value: '\xE6\xB1\x9F\xE5\xAE\x81...' for column 'unitname' at rowMySql
- 【MySQL】Incorrect string value 問題一則MySql
- ORACLE匯出文字到MYSQL 報錯 Incorrect integer value: ''OracleMySql
- pymysql.err.OperationalError: (1136, “Column count doesn‘t match value count at row 1“)報錯反省。MySqlError
- 安裝mysql遇到ERROR: 1136 Column count doesn't match value count at row 1MySqlError
- java.sql.SQLException: Incorrect string valueJavaSQLException
- MYSQL寫入資料時報錯ERROR 1366 (HY000): Incorrect string value: '\xE8\x8B\xB1\xE5\xAF\xB8...' for c 插入中文不能插...MySqlError
- MySQL: Incorrect string value: '\xF0\xA4\xBD\x82'分析MySql
- PHP連線SQL資料庫無法顯示emoji表情的解決辦法(變成問號、1366 Incorrect string value)PHPSQL資料庫
- python 讀取txt出現\xef\xbb\xbf…的問題Python
- 解決:java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\x94‘ for columnJavaSQLException
- python 列印陣列中文顯示為'\xe6\xb5\x8b\xe8\xaf\x95\xe4\xb8\xbb\xe6\x9c\xba‘’Python陣列
- 解決 Incorrect datetime value: '0000-00-00 00:00:00' 報錯
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error
- Convert DataFrame string complex i to j python // “Cloning” row or column vectorsPython
- Mybatis Data truncation: Truncated incorrect DOUBLE value: '*'MyBatis
- MySQL插入資料1366錯誤解決方案MySql
- Flutter 之 Row、Column詳解Flutter
- mysql 主從同步 Error 'Out of range value for column的問題MySql主從同步Error
- kettle建立資源庫Incorrect integer value
- MySQL 5.5 報錯"ERROR 1075 (42000): Incorrect table definition"MySqlError
- Flutter之Row/Column用法詳解Flutter
- Flutter基礎元件Row&ColumnFlutter元件
- Data too long for column 'name' at row 1 mysql的丟擲異常的解決辦法--之前方法不管用-要設定資料庫編碼MySql資料庫
- MySQL錯誤Incorrect file format解決方案薦MySqlORM
- Flutter控制元件--Row、Column和StackFlutter控制元件
- Flutter線性佈局Row和ColumnFlutter
- Flutter 佈局(七)- Row、Column詳解Flutter
- 鴻蒙HarmonyOS實戰-ArkUI元件(Row/Column)鴻蒙UI元件
- MySQL could not be resolved: Temporary failure in name resolution報錯解決方法MySqlAI
- MySQL問題記錄--python插入中文至MySQL提示SQLErroor:1366錯誤MySqlPython
- Flutter 佈局控制元件篇-->Row、ColumnFlutter控制元件
- vue報錯:[Vue warn]: Invalid prop: type check failed for prop "value". Expected Number, got String....VueAIGo
- MySQL 5.7 Invalid default value for 'CREATE_TIME'報錯的解決方法MySql
- mysql匯入報錯Variable 'sql_notes' can't be set to the value of 'NULL'MySqlNull