Re: How do I load extended (accented) ascii characters from text files?

> Thanks for that reply, that will help when I start coding the webpage. But
> at the moment I am trying to load a text file of data taken out of MS
ACCESS
> into MySQL running on my WIN 2000 system, and it is not handling the
> extended characters properly. Is there a way to get my WINDOWS system to
> handle these characters properly when I bulk load this text file?
What codepage you use for data stored in MySQL? Win1252? If yes and if
textfile is in the same codepage I have no idea. If you use iso-8859-2 in
MySQL and textfile is inWin1252 you must convert the textfile to appropriate
codepage before load it (find some freeware utility on the web), or write
simple script in php where you read the textfile row by row, recode strings
to other codepage and store to table.

Petr Vileta, Czech Republic
http://www.practisoft.cz



---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10604@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.