I am using LOAD DATA INFILE to populate a mysql db. I prepare the file in Excell and save it as csv format. Every works fine... except that the file contains special characters with accent or symbols. Is there a way to import such text field directly or do I need to escape all these special characters before?
i.e the german word for piece "Stück" is inserted as "Stck" in mysql table.
Do I have to insert a backslash before each special char "St\ück" in the excell file?
--
Kind regards, Paul.
Gondwana [EMAIL PROTECTED] http://www.gondwanastudio.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
