var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Importing data to mysql that contains foreign charecters
I have a .sql file created in notepad which I need to populate my database with. Up until now I was simply using
mysql -u root -p testdb < test.sql
However, I noticed that foreign charecters like é or ñ for example were not being converted properly. They showed as weird squiggles when I looked in the mysql client at the data.
The line I used to create the database included collation and character set information:
CREATE DATABASE testdb CHARACTER SET utf8 COLLATE utf8_unicode_ci;
and then no other collation and chareceter set information i.e for the tables.
The é or ñ type charecters show fine in the mysql client if I input them directly though the client.
However I can't load the data in directly through the client becuase there is too much data !
I tried using :
mysql -u root -p testdb --default-character-set=utf8 < test.sql
No errors were given at the command line, but the foreign charecters still show as weird squiggles in the mysql client, albeit different weird squiggles.
Any help would be great.
Last edited by ed65; 07-09-11 at 14:33.