Chapter 15.1 Database

[tomliuwhite]

I am working on WindowsXP with wampserver.

I am trying to insert the info to the database of forum2, so I copied below data from file: sql_utf8.sql:

INSERT INTO languages (lang, lang_eng) VALUES

('English', 'English'),

('Português', 'Portuguese'),

('Français', 'French'),

('Norsk', 'Norwegian'),

('Romanian', 'Romanian'),

('Ελληνικά', 'Greek'),

('Deutsch', 'German'),

('Srpski', 'Serbian'),

('日本語', 'Japanese'),

('Nederlands', 'Dutch');

 

And I pasted it on the mysql command window, it showed(see below picture):

http://hi.baidu.com/tomliuwhite/album/item/b36ca95ef8198618c766d9c94aed2e738ad4e6e4.html#

 

And it did not work. So what is this problem?

[Larry]

You're not setting the character set in the mysql connection prior to pasting that query.

[tomliuwhite]

Got it. Thanks.