problem in table population

davidklonski

Hello

I have the following table:

CREATE TABLE language_settings (
  Language_ID INT UNSIGNED NOT NULL,
  Lang_Code CHAR(2) NOT NULL,
  ISO_Code [B]CHAR(5)[/B] 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;

I populate this table using:
LOAD DATA INFILE 'languageSettings.sql' INTO TABLE language_settings;

Here is the content of languageSettings.sql:

[B]1[/B]	EN	en_US	English	English	ltr
2	HE	he_IW	Hebrew	?????	rtl
3	FR	fr_FR	French	Français	ltr

For some reason, after the table is populated I get an incorrect langauge_id for the English language:

select * from language_settings;

+-------------+-----------+----------+--------------+-------------+-----+
| Language_ID | Lang_Code | ISO_Code | English_Name | Locale_Name | DIR |
+-------------+-----------+----------+--------------+-------------+-----+
|           [COLOR=Red]0[/COLOR] | EN        | en_US    | English      | English     | ltr |
|           2 | HE        | he_IW    | Hebrew       | +ó+?+¿+?+¬  | rtl |
|           3 | FR        | fr_FR    | French       | Fran+ºais   | ltr |
+-------------+-----------+----------+--------------+-------------+-----+

Somehow the language_id for the first row became 0 instead of 1.
Does anyone know what I am doing wrong?
BTW, I am using MySQL 5.0

Sxooter

MySQL is having a problem reading the number on that row, and is substituting the default for a not null int field, 0. I.e. instead of erroring out like a normal database should, it's guessing at what it thinks you want.

davidklonski

You are correct.

I have opened the .sql file in a more advanced text editor (than the stupid notepad) and saw the BOM (Byte Order Mark) that was added at the beginning of the file.
The BOM was added because the file was saved in UTF8.