MySQL Invalid gbk character string 1300
今天給表新增列的時候出現一個warning
新增語句,可以看到是包含中文的
把語句貼上到命令視窗裡的時候就亂碼了,雖然新增成功,但是報warning
檢視warning,code 1300
字符集問題
解決辦法是
修改vim /etc/sysconfig/i18n 檔案 ,最後兩行是新新增的,上面的是剛剛遮蔽的,為啥不好用呢,因為沒帶雙引號
儲存檔案後執行source /etc/sysconfig/i18n
新增語句,可以看到是包含中文的
- ALTER TABLE `lidan_follow` ADD `assess` TINYINT NOT NULL DEFAULT '-1' COMMENT '-1:未評價 0:不認真 1:認真' AFTER `mylevel`;
-
(root@localhost) [oms3]> ALTER TABLE `lidan_follow` ADD `assess` TINYINT NOT NULL DEFAULT '-1' COMMENT '-1: 0: 1:' AFTER `mylevel`;
-
Query OK, 0 rows affected, 1 warning (4.79 sec)
- Records: 0 Duplicates: 0 Warnings: 1
-
(root@localhost) [oms3]> show warnings;
-
+---------+------+----------------------------------------------------+
-
| Level | Code | Message |
-
+---------+------+----------------------------------------------------+
-
| Warning | 1300 | Invalid gbk character string: '-1:\xE6\xAA\xE8...' |
-
+---------+------+----------------------------------------------------+
- 1 row in set (0.00 sec)
-
[root@oracle11gtest ~]# perror 1300
- MySQL error code 1300 (ER_INVALID_CHARACTER_STRING): Invalid %s character string: '%.64s'
修改vim /etc/sysconfig/i18n 檔案 ,最後兩行是新新增的,上面的是剛剛遮蔽的,為啥不好用呢,因為沒帶雙引號
-
#LANG=en_US.UTF-8
-
#SYSFONT=latarcyrheb-sun16
-
LANG="en_US.UTF-8"
- SYSFONT="latarcyrheb-sun16"
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20893244/viewspace-2134452/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- python character stringPython
- Python 錯誤 SyntaxError: invalid character in identifierPythonErrorIDE
- Java - XML字元支援報錯An invalid XML characterJavaXML字元
- SAXParseException An invalid XML character 問題的解決ExceptionXML
- An invalid XML character (Unicode: 0x18) was foundXMLUnicode
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- mysql支援gbk(zt)MySql
- MySQL ODBC配置遇到Invalid attribute string錯誤資訊的處理MySql
- Swift中String和Character的使用與總結Swift
- IllegalArgumentException: Invalid character found in method name. HTTP method names must be tokensExceptionHTTP
- An invalid XML character (Unicode: 0x10) was found in the value of attributeXMLUnicode
- An invalid XML character (Unicode: 0x4) was found in the element content of theXMLUnicode
- LeetCode C++ 387. First Unique Character in a String【String/Hash Table】簡單LeetCodeC++
- 【Mysql】character-set-server引數MySqlServer
- Error parsing XML: An invalid XML character (Unicode:0x1f) was foundErrorXMLUnicode
- xml問題請教:org.xml.sax.SAXParseException: Invalid encoding name "GBK".XMLExceptionEncoding
- PHP 對字串進行十六進位制替換 invalid character in attribute valuePHP字串
- java.sql.SQLException: ORA-00911: invalid character 解決方法(轉)JavaSQLException
- 對XML 進行 parse 時的Invalid Unicode character (0x0) 分析XMLUnicode
- 微信公眾號 報 An invalid XML character (Unicode: 0x1a) was found in the CDATA sectioXMLUnicode
- All About JAVA An invalid XML character (Unicode: 0xdd65) was found in the comment 錯誤JavaXMLUnicode
- Dom4j 讀 xml 時,遇到 xml 無效字元,報錯:An invalid XML characterXML字元
- err Invalid input of type: 'dict'. Convert to a byte, string or number first
- day1 UnicodeEncodeError: 'gbk' codec can't encode character '\xa0' in position 2490: illegal multi...UnicodeError
- mysql關於字符集character set的總結MySql
- rhel4 mysql5.5 字符集_character setMySql
- MySQL字符集和校對規則(character set & collation)MySql
- 已解決:Invalid character found in the request target. The valid characters are defined in RFC 7230 and RFC 3986 問題
- MySQL:簡單記錄character_set_server影響引數MySqlServer
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- 演算法-First Unique Character in a String-字串中的第一個唯一字元演算法字串字元
- 關於MySQL中的8個 character_set 變數說明MySql變數
- 常見物件-Character物件
- vue報錯:[Vue warn]: Invalid prop: type check failed for prop "value". Expected Number, got String....VueAIGo
- npm報錯 TypeError [ERR_INVALID_ARG_TYPE]: The “path“ argument must be of type string.Received undefineNPMError
- 【python爬蟲】用selenium爬時報錯UnicodeEncodeError: ‘gbk‘ codec can‘t encode character ‘\u2022‘Python爬蟲UnicodeError
- 查LOB文字內容報錯ORA-06502: numeric or value error: character string buffer..Error
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull