An improvement to the Chinese support for MySQL 5.1

MySQL 5.1 's Chinese support for an improvement, starting from MySQL 4.1 does not support Chinese path, file name problem solved.

See the following example

Microsoft Windows XP [version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and settings\administrator>runas/user:aaa cmd

Enter the AAA password:

Attempt to start cmd as user "my-tomato\aaa" ...

C:\Documents and Settings\Administrator>cd \mysql51\bin

C:\mysql51\bin>mysql -u root
Welcome to the MySQL monitor.　Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.7-beta-community

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| tr　　　　　　 |
| trb3　　　　　 |
+----------------+
2 rows in set (0.00 sec)

mysql> desc tr;
+-----------+-------------+------+-----+---------+-------+
| Field　　 | Type　　　　| Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| id　　　　| int(11)　　 | YES　|　　 | NULL　　|　　　 |
| name　　　| varchar(50) | YES　|　　 | NULL　　|　　　 |
| purchased | date　　　　| YES　|　　 | NULL　　|　　　 |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> insert into tr (id,name) values(1,'EWR'),(2,'SR'),(3,'GH');
Query OK, 3 rows affected (0.00 sec)
Records: 3　Duplicates: 0　Warnings: 0

mysql> select * from tr into outfile 'c:/mysql51/猪八戒.txt';
Query OK, 11 rows affected (0.00 sec)

mysql> select * from tr into outfile 'c:/mysql51/新建文件夹/猪八戒.txt';
Query OK, 11 rows affected (0.02 sec)

mysql> create table tr2 as select * from tr limit 0;
Query OK, 0 rows affected (0.06 sec)
Records: 0　Duplicates: 0　Warnings: 0

mysql> select * from tr2;
Empty set (0.00 sec)

mysql> load data infile　'c:/mysql51/新建文件夹/猪八戒.txt' into table tr2;
Query OK, 11 rows affected (0.00 sec)
Records: 11　Deleted: 0　Skipped: 0　Warnings: 0

mysql>
C:\mysql51\bin>mysqladmin -u root shutdown

C:\mysql51\bin>cd \mysql50\bin

C:\mysql50\bin>mysql -u root
Welcome to the MySQL monitor.　Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> CREATE TABLE tr (id INT, name VARCHAR(50), purchased DATE)
　　 -> ;
Query OK, 0 rows affected (0.05 sec)

mysql> load data infile　'c:/mysql51/新建文件夹/猪八戒.txt' into table tr;
ERROR 29 (HY000): File 'c:\mysql51\脨脗陆篓脦脛录镁录脨\脰铆掳脣陆盲.txt' not fo
und (Errcode: 2)
mysql>