[Kexi] problems importing from MySQL database

Jarosław Staniek js at iidea.pl
Sun Oct 21 00:05:19 CEST 2007


stretchoutandwait at gmail.com said the following, On 2007-10-20 23:52:

> I'm trying to import a database from MySQL.  In MySQL's CLI interface,
> in phpMyAdmin, and in Knoda, it works fine.  Unfortunately, when I try
> to import to Kexi, I get strange results.  The type of several fields
> becomes 'blob,' and the contents are also odd--things like "[BLOB -
> 7B]" and "[BLOB - 15 B]".  In the source db, these fields are of the
> type longtext.

Hello stretchoutandwait,
Have you seen this?
http://kexi-project.org/wiki/wikiview/index.php?Kexi1.1.3_Patches#A_fix_for_importing_columns_of_type_long_text_from_MySQL_server

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org



More information about the Kexi mailing list