HP OpenSource MySQL 5.0 ver. 1.0 1
MySQL Server 5.0 MySQL Server 5.0 MySQL Server MySQL Server MySQL Server MySQL Character Set MySQL Character Set 1 MySQL Server MySQL Server 5.0 2 MySQL Server 5.0 MySQL Server 5.0 3 MySQL Server 5.0 Appendix1: Appendix2: Appendix3: MySQL Server 2
... 2... 2... 2... 3 1 MySQL Server... 4 1.1 MySQL Server... 4 1.2 MySQL Server... 5 2 MySQL Server... 5 2.1 MySQL Server(mysqld)... 5 2.1.1... 5 2.1.2... 6 2.2... 6 2.2.1... 6 2.2.2... 6 2.3... 7 2.3.1... 7 2.3.2... 7 2.4... 7 2.4.1... 7 2.4.2... 7 3... 8 3.1 mysql... 8 3.1.1... 8 3.1.2... 8 3.2 Java... 9 3.2.1... 9 3.2.2... 9 Appendix 1:... 10 MySQL Server... 10... 10 Appendix 2:... 10... 10 Windows Vista... 10 Java EUC_JP_Solaris... 11 Appendix 3: MySQL Server... 11 Windows... 11 Unix...12 3
MySQL Server 5.0 MySQL Server 1 MySQL Server MySQL MySQL Server MySQL Server MySQL Server MySQL Server MySQL Server Unicode(ucs2) 1.1 MySQL Server MySQL Server 4
2. MySQL Server MySQL Server 1.2 MySQL Server MySQL Server 5.0 MySQL cp932 eucjpms utf8 Shift-JIS Windows CP932 (JIS X201 JIS X208 NEC NEC IBM IBM ) EUC-JP cp932 RFC3629 UTF-8 3 UTF-8 Unicode BMP : MySQL sjis eucjp Windows NEC sjis cp932 eucjp eucjpms 2 MySQL Server 1.1 MySQL Server MySQL Server 2.1 MySQL Server(mysqld) 2.1.1 MySQL Server(mysqld) MySQL (my.cnf my.ini) [mysqld] character_set_server [mysqld] character_set_server = cp932 : MySQL Appendix 3: MySQL Server MySQL Server character-set-server #./bin/mysqld --character-set-server=eucjpms --user=mysql & 5
: my.cnf character_set_server MySQL Server character-set-server --character-set-server 2.1.2 MySQL Server(mysqld) character_set_server mysql> SHOW VARIABLES LIKE 'character_set_server'; +----------------------+---------+ Variable_name Value +----------------------+---------+ character_set_server cp932 +----------------------+---------+ 1 row in set (0.00 sec) 2.2 2.2.1 CREATE DATABASE CHARACTER SET mysql> CREATE DATABASE db_cp932 CHARACTER SET cp932; CHARACTER SET MySQL Server(mysqld) 2.2.2 information_schema SCHEMATA mysql> use information_schema mysql> SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME FROM SCHEMATA WHERE SCHEMA_NAME = 'db_cp932'; +-------------+----------------------------+ SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME +-------------+----------------------------+ db_cp932 cp932 +-------------+----------------------------+ 1 row in set (0.01 sec) character_set_database mysql> SHOW VARIABLES LIKE 'character_set_database'; +------------------------+---------+ Variable_name Value +------------------------+---------+ character_set_database cp932 +------------------------+---------+ 1 row in set (0.00 sec) 6
2.3 2.3.1 CREATE TABLE CHARACTER SET mysql> CREATE TABLE tb1_cp932 (id int, name varchar(100)) CHARACTER SET cp932; CHARACTER SET 2.3.2 SHOW CREATE TABLE mysql> SHOW CREATE TABLE tb1_cp932\g *************************** 1. row *************************** Table: tb1_cp932 Create Table: CREATE TABLE `tb1_cp932` ( `id` int(11) default NULL, `name` varchar(100) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=cp932 1 row in set (0.00 sec) 2.4 2.4.1 CREATE TABLE CHARACTER SET mysql> CREATE TABLE tb2_cp932 (id int, name varchar(100) CHARACTER SET cp932); CHARACTER SET 2.4.2 information_schema COLUMNS mysql> SELECT COLUMN_NAME, CHARACTER_SET_NAME FROM COLUMNS WHERE TABLE_NAME = 'tb2_cp932'; +-------------+--------------------+ COLUMN_NAME CHARACTER_SET_NAME +-------------+--------------------+ id NULL name cp932 +-------------+--------------------+ 2 rows in set (0.01 sec) 7
3 MySQL Server 5.0 MySQL Server mysql Java 3.1 mysql 3.1.1 mysql ( mysql) MySQL (my.cnf my.ini) [mysql] default-character-set mysql $ cat /etc/my.cnf... [mysql] default-character-set = cp932... $./bin/mysql -u root : MySQL Appendix 3: MySQL Server my.cnf mysql default-character-set=< > $./bin/mysql -u root --default-character-set=cp932 (1) : my.cnf default-character-set mysql default-character-set mysql default-character-set (2) : mysql mysql latin1 mysql 3.1.2 mysql SHOW VARIABLES LIKE char% ; character_set_client character_set_connection character_set_results mysql> SHOW VARIABLES LIKE 'char%'; +- -------------------------------------------------------+ Variable_name Value +--------------------------+------------------------------+ character_set_client cp932 character_set_connection cp932 character_set_database eucjpms character_set_filesystem binary character_set_results cp932 character_set_server eucjpms character_set_system utf8 8
character_sets_dir /mysql/share/mysql/charsets/ +--------------------------+------------------------------+ 3.2 Java Java MySQL Server MySQL MySQL Server JDBC Connector/J 3.2.1 Java MySQL Server JDBC URL characterencoding= Java > Java Connector/J MySQL MySQL cp932 eucjpms utf8 Java Windows-31J MS932 EUC_JP_Solaris UTF-8 : MySQL sjis ujis sjis Java SJIS ujis Java EUC_JP Java Windows-31J MySQL Server Class.forName( com.mysql.jdbc.driver ); Connection conn = DriverManager.getConnection( jdbc:mysql://localhost:3306/test +?user=dbuser&password=dbpass&characterencoding=windows-31j"); 3.2.2 Java SHOW VARIABLES LIKE char% Statement stmt = conn.createstatement(); ResultSet rs = stmt.executequery("show VARIABLES LIKE 'char%'"); while (rs.next()) { String key = rs.getstring(1); // char_* String val = rs.getstring(2); // System.out.println(key + " : " + val); } stmt.cl ose(); conn.close(); 9
Appendix 1: MySQL Server MySQL Server (1) my.cnf [mysqld] SHOW VARIABLES LIKE (mysqld) character_set_server = < > character_set_server (2) MySQL Server character-set-server=< > CREATE DATABASE CHARACTER SET SHOW VARIABLES LIKE character_set_database CREATE TABLE CHARACTER SET SHOW CREATE TABLE CREATE TABLE information_schema CHARACTER SET COLUMNS CHARACTER_SET_NAME mysql (1) default-character-set=< SHOW VARIABLES LIKE char% Java (2) my.cnf [mysql] default-character-set = < > JDBC URL characterencoding=<java > - character_set_client - character_set_connection - character_set_result Java SHOW VARIABLES LIKE char% Appendix 2: MySQL Server ( ) MySQL Server 5.0 ( ) UTF-8 MySQL Server OS( ) or ( ) OS MySQL Server 5.0 / MySQL Server 5.1 Windows Vista Windows Vista JIS X 0213:2004(JIS2004) UTF-8 4 10
MySQL Server Windows Vista UTF-8 4 MySQL Server MySQL Server 5.0 UTF-8 3 UTF-8 4 UTF-8 4 MySQL Server 5.0 Windows Vista JIS X 0213:2004(JIS2004) MySQL Server Connector MySQL 6.0 MySQL Server 5.0 UTF-8 4 (VARBINARY/BLOB) 1 =1 CHAR_LENGTH() Java EUC_JP_Solaris MySQL Server eucjpms Java EUC_JP_Solaris MySQL Server eucjpms Java EUC_JP_Solaris WIndows-31J UTF-8 JDBC URL characterencoding=windows-31j&charactersetresults=windows-31j characterencoding=utf-8&charactersetresults=utf-8 MySQL Server eucjpms Java MySQL Server Unicode(ucs2) Appendix 3: MySQL Server MySQL Server (my.cnf my.ini) MySQL Server MySQL Server Windows Windows MySQL Server WINDIR\my.ini C:\my.ini INSTALLDIR\my.ini --defaults-extra-file=< > WINDIR Windows echo %WINDIR% INSTALLDIR MySQL Server 11
Unix Unix MySQL Server /etc/my.cnf $MYSQL_HOME/my.cnf --defaults-extra-file=< > ~/.my.cnf $MYSQL_HOME $MYSQL_HOME mysqld_safe MySQL Server $MYSQL_HOME MySQL BASEDIR DATADIR BASEDIR my.cnf DATADIR my.cnf $MYSQL_HOME DATADIR $MYSQL_HOME BASEDIR 12
03-5304-6660 9:00 19:00 10:00 18:00 Linux/ http://www.hp.com/jp/linux/ 2007 4 HP Copyright 2007 Hewlett-Packard Development Company,L.P. 102-0076 7 13