mysql error

T

terry

The following is a portion of my mysql script. When I run it, the line

INSERT INTO cat VALUES (16,'套餐',1);//error line

raises an error

outfile disabled

unknown command '\?

:
:
CREATE TABLE `cat`
(
`id` int unsigned NOT NULL auto_increment,
`name` text NOT NULL,
`catid` int,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
)
TYPE=MyISAM;
:
:
INSERT INTO cat VALUES (14,'炒飯',6);
INSERT INTO cat VALUES (16,'套餐',1);//error line

:
:

I have checked that the chinese character "餐" raise the error.
Do anyone know why and how to solve it?
 
L

Loic Minier

* terry said:
I have checked that the chinese character "餐" raise the error.
Do anyone know why and how to solve it?

What is the encoding of your base? Wouldn't a mysql-newsgroup be more
adapted?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top