DBTools Software - Forums

Anonymous

Home » Forums » Bug Report and Fixes

Importing dbase III file to MySQL (2496 previews)
Importing dbase III file to MySQL	Posted in 07th, 11/2005 05:56 by hquazilbash
When I try to import a dbaseIII file, I get an error "Display width out of range for column 'xxx' (max = 255) and all decimal fields are shown as double (0,0)! what am I doing wrong. I downloaded the latest dbManager and still get the error. Haider /
Re: Importing dbase III file to MySQL	Posted in 07th, 11/2005 07:03 by support
Hi, Could you send us a copy of the table being imported? If yes please attach it to support@dbtools.com.br. Best Regards, Support / DBTools Software
Re: Importing dbase III file to MySQL	Posted in 14th, 12/2005 11:34 by support
Hi Haider, It is a bug indeed. Not in the application but in the DBManager catalog. The catalog distributed with DBManager was changed but some type conversion were incorrect. To fix it follow the steps: - Open DBManager - Select the menu option Tools => Data Management => Type Conversion - Select the source engine MS DAO Access - Select the target engine MySQL - Edit the conversion for Double => Double - Change the destination size and decimals to 20 and 4 respectivelly - Do the same for type conversion Float => Float That's it. As MSAccess doesn't not support the types DOUBLE and FLOAT with precisions (In SQL terms) the conversion is wrong for MySQL as it tries to create a field with DOUBLE(0,0). Using the approach above it will convert the fields to DOUBLE(20,4) or FLOAT(20,4) which is suitable for most cases. Best Regards, Support / DBTools Software
RE: Importing dbase III file to MySQL	Posted in 25th, 03/2015 04:45 by linmikey
You get the sense that Pele knows iphone 6 plus protective film what you are going to ask him even before you start to formulate the words. Double Sided Adhesive Perhaps it is just natural intuition, the same instinctive understanding for human behaviour—and how he can use that to his own advantage—that die cut helped make him the greatest footballer, and the most prolific goalscorer, Stand Up Pouches the sport has ever seen. zenok5528 /
Importing dbase III file to MySQL (2496 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » Bug Report and Fixes