MySQL Forums
Forum List  »  Data Recovery

Import SQL file from codepage 850 to Latin1
Posted by: Ben van der Beek
Date: March 28, 2011 02:11PM

I have a simple problem, so a simple question, but am not able to find the solution. I have old data made with a MSDOS application in Codepage 850 dbase files. I dumped this data in sql files ( creating the table and inserting the rows) and I want to import this Codepage 850 data into my new Mysql database that uses Codepage Latin1 general ci.

What commmand in the mysql console should I use to import the old data in a Codepage 850 sql file (eg olddata.sql) to my new mysql database (eg newdb) ?
Performing a simple import eg with the SOURCE command does import the data but corrupts special characters.

Ben.

Options: ReplyQuote


Subject
Views
Written By
Posted
Import SQL file from codepage 850 to Latin1
3415
March 28, 2011 02:11PM


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.