Hi, > Hi guys, > I'm doing a data migration from oracle to MySQL. > There is a table including BFILE datatype column on the Oracle, but I can't find the replacement in MySQL, Would anyone like to give me some advice or solutions?
A BFILE is nothing more than a filename really, except that it can be accessed as if it were a blob directly in the database. You can do one of two things: 1) store a filename and create some routine that gets the file from the file system or 2) store the blob inside your database. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
