Unable to create table with Unicode characters in name

Question

I am creating a table in 【Navicate for MySQL but cannot complete it.

this is my code.

CREATE table `成绩表`( `学号` char(10), `课号` char(10), `成绩` int, PRIMARY KEY(`学号`, `课号`) ) error: [SQL] CREATE table `成绩表`( `学号` char(10), `课号` char(10), `成绩` int, PRIMARY KEY(`学号`, `课号`) ) [Err] 1005 - Can't create table '成绩表' (errno: 22) 

Answer 1

According to the MySQL manual , it can handle unicode from U + 0001 to U + FFFF for table and column names - so the reason for you is likely to take some digging:

The error message says that errno is 22 , which IIRC translates into an OS error code for invalid argument . This, in turn, means that somewhere deep down inside MySQL itself there is some function called with an argument that it cannot accept.

I would suspect that the called function is from the C and / or OS runtime and that it is most likely related to the file system.

This, in turn, means either an error or some obscure MySQL behavior interacting with the OS / file system / installation you are using ...

I would recommend definitely contacting MySQL / Oracle about this, since this IMHO is far beyond what SO can handle ...