Hi all,
My web application uploads files from MySQL database.
I have the text in ms word *.doc files, so I convert it to *.txt as UNICODE-UTF8, and mysql table charset is set to UTF8.
I load the database entering this command:
LOAD DATA local INFILE 'file.txt' INTO TABLE tab;
I'm getting some problems here with the charset enconding. For example this text:
Amente E ainda os escravos algũas horas podem folgar sem culpa, chorar podem todas. Nam é a sojeição cousa que assi se possa sofrer e a mi
is loaded to the database like this:
----
´╗┐
I also converted the *.doc file to web page *.htm and I got this loaded into mysql database:
|
<p class=MsoNormal><span class=131estrangeiros1559><span style='mso-tab-count:
|
1'>┬á┬á┬á┬á┬á┬á┬á┬á┬á┬á┬á┬á┬á┬á┬á </span>E ainda os escravos alg┼®as horas pod
|
|ojeição</span></p>
Please, can you give me any advice?
Thank you