MySQL Forums
Forum List  »  SQLite

BLOB type for Sqlite to MySQL export
Posted by: DUS Jean-Claude
Date: June 21, 2012 02:45PM


I'm converting tables from Sqlite to MySQL. All is fine except for png pictures with BLOB type in Sqlite.

How can I convert those data keeping the same BLOB type in MySQL ? Can you suggest me a tool to do this ? is ANSI or utf-8 encoding important for this export ?

For your information, the Sqlite database comes from uWamp and the Sqlite Manager interface in uWamp includes a MySQL export option. But the BLOB type data (png pictures) do not appear anymore in the file exported for MySQL.

Thanks in advance.

Options: ReplyQuote

Written By
BLOB type for Sqlite to MySQL export
June 21, 2012 02:45PM

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.