Please Help!
Posted by: Zas Nemone
Date: October 24, 2005 03:12PM

Ok. My problem is that I have a database with MySQL version : 4.1.10a on my Localhost. I want to export that database so I can import it to my server's MySQL 3.23.58. The problem is that when I import it doesn't convert my UTF8 sql file to ISO, as it gives me error on this line "ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=163", so I am forced to write only "TYPE=MyISAM", and doing that just leaves it in UTF8 format. So in my website all my á é í ó ú and ñ characters show up in strange characters. How can I convert my database to ISO (remember that i can't select collation of the tables in MySql 3)?

Thanks a lot!

Options: ReplyQuote

Written By
Please Help!
October 24, 2005 03:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.