rhel4 mysql5.5 字符集_character set
和oracle字符集一樣,有些暈,太細了
小結:
1,字符集分為:伺服器,資料庫,表,連線,列等
對應引數為:
mysql> show variables like 'chara%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | gb2312 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | gb2312 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show variables like 'collation%';#類似於oracle show parameter呵呵
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | gb2312_chinese_ci |
| collation_server | gb2312_chinese_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | gb2312_chinese_ci |
| collation_server | gb2312_chinese_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
mysql>
2,建立或修改字符集
create dababase zxy character set gb2312;
alter database zxy character set gb2312;
set character_set_server=latin;
啟動mysqld指定default_character_set引數
配置/etc/my.cnf中的client及server節關於default_character_set引數
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-665625/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MYSQL5.5修改字符集報錯:unknown variable 'default-character-set=utf8'MySql
- 【轉】修改Oracle字符集(character set)Oracle
- Oracle 10中修改字符集(character set)Oracle
- mysql關於字符集character set的總結MySql
- MySQL字符集和校對規則(character set & collation)MySql
- rhel4 mysql5.5字符集_客戶端mysql亂碼處理MySql客戶端
- 匯入rhel4 mysql5.5到rhel4 mysql5.1MySql
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- rhel5_oracle10g_10.2.0.4_字符集character set_nls_valid_valueOracle
- Indexing Mixed-Character Set ColumnsIndex
- character_set_database的意義Database
- 【Mysql】character-set-server引數MySqlServer
- MySQL環境變數裡關於字符集character_set相關引數的解釋MySql變數
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- Variable 'character_set_client' can't be set to the value of Null的解決方法clientNull
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull
- mysqlbinlog: unknown variable 'default-character-set=utf8'MySql
- MySQL:簡單記錄character_set_server影響引數MySqlServer
- B19306_01 閱讀筆記(character set)筆記
- 關於MySQL中的8個 character_set 變數說明MySql變數
- 在rhel5上oracle10.2.0.4用sql指令碼生成儲存過程註解亂碼處理_character set_字符集OracleSQL指令碼儲存過程
- oracle exp&imp之IMP-00037: Character set marker unknownOracle
- 【nls_character】中文字元亂碼問題與字符集的修改字元
- Changing Primary DB Character Set without Recreate DG Physical Standby_1124165.1
- configuring Csscan in 10g and 11g (Database Character Set Scanner)_745809.1CSSDatabase
- error MSB8031 Building an MFC project for a non-Unicode character set is deprecatedErrorUIProjectUnicode
- AL32UTF8 / UTF8 (Unicode) Database Character Set Implications [ID 788156.1]UnicodeDatabase
- 啟動PL/SQL Developer 報字元編碼不一致錯誤,Database character setSQLDeveloper字元Database
- mysql5.5安裝MySql
- 安裝mysql5.5MySql
- CMAKE安裝mysql5.5MySql
- 常見物件-Character物件
- 解決:錯誤 1 error MSB8031: Building an MFC project for a non-Unicode character set is deprecatedErrorUIProjectUnicode
- mysql5.5 performance_schema 初探MySqlORM
- Swift 字元(Character)講解Swift字元
- python character stringPython
- java lang包下Character類Java
- Hive throws: WstxParsingException: Illegal character entity: expansion character (code 0x8)HiveException