tomliuwhite Posted December 28, 2011 Share Posted December 28, 2011 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? Link to comment Share on other sites More sharing options...
Larry Posted December 28, 2011 Share Posted December 28, 2011 You're not setting the character set in the mysql connection prior to pasting that query. Link to comment Share on other sites More sharing options...
tomliuwhite Posted December 29, 2011 Author Share Posted December 29, 2011 Got it. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts