Hi, I've read the man pages on this, but I can't figure out what to do. I have = a tab-delimited textfile containing spanish characters. I import those record= s using LOAD DATA INFILE... . All the special spanish chars are converted to something different. How can I correct this? The columns in question are al= l created as VARCHAR and BINARY is not set for those columns.
My default charset is Latin1. Other charsets installed are: latin1=A0dec8=A0dos=A0german1=A0hp8=A0koi8_ru=A0latin2=A0swe7=A0usa7=A0cp1251=A0danish=A0hebrew=A0 win1251=A0estonia=A0hungarian=A0koi8_ukr=A0win1251ukr=A0greek=A0win1250=A0croat=A0cp1257=A0 latin5 Mysql verison 3.32.47 OSX. Do I need another charset? Please help, Juergen Schreck --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
