I have the following table:
Code: Select all
CREATE TABLE language_settings (
Language_ID INT UNSIGNED NOT NULL,
Lang_Code CHAR(2) NOT NULL,
ISO_Code CHAR(5) NOT NULL,
English_Name VARCHAR(255) NOT NULL,
Locale_Name VARCHAR(255) NOT NULL,
DIR CHAR(3) NOT NULL,
PRIMARY KEY (Language_ID)
) ENGINE=MYISAM;LOAD DATA INFILE 'languageSettings.sql' INTO TABLE language_settings;
Here is the content of languageSettings.sql:
Code: Select all
1 EN en_US English English ltr
2 HE he_IW Hebrew ????? rtl
3 FR fr_FR French Franחais ltrselect * from language_settings;
Code: Select all
+-------------+-----------+----------+--------------+-------------+-----+
| Language_ID | Lang_Code | ISO_Code | English_Name | Locale_Name | DIR |
+-------------+-----------+----------+--------------+-------------+-----+
| 0 | EN | en_US | English | English | ltr |
| 2 | HE | he_IW | Hebrew | +ף+?+¿+?+¬ | rtl |
| 3 | FR | fr_FR | French | Fran+÷ais | ltr |
+-------------+-----------+----------+--------------+-------------+-----+Does anyone know what I am doing wrong?
BTW, I am using MySQL 5.0