I have the following UTF-8 file exported from a microsoft access file
I have ensured my mysql database is utf8 with the status; command for both client and server. I insert the above file into my database with the following command:
LOAD DATA LOCAL INFILE 'tblAuction1.txt' INTO TABLE Auctions FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\';
All seems to be going kind of OK, unicode characters are displayed in the html as they should be as far as I can tell. The direct contents of the database field is here:
However the resulting html code is displayed:
Which displays as
1.00 <\/OBJECT> '); \t\t<\/SCRIPT> \t\t
in the browser
The code I am using to show this is:
which was working fine before I changed the encoding.
as a side question, I am wondering why changing from tab delimited to semicolon delimited, and enclosing fields would ddecrease the size of the exported file by half. The tab character is a single character just like the ; character, and adding quotes to enclose should have increased the size?