[Solved] Import to MySQL db 'No Corresponding Column Type'
Posted: Sun Jun 20, 2010 5:31 pm
I created a database using the MySQL community server. I wanted to import data into it from a Base database.
I dragged the table definition into the MySql database, although it warned me that column types were not recognised (I changed them to what I hoped were recognisable types and the definition imported and looked ok) I was able to type a row of data into it. But when I tried to append the actual data from Base, I got a warning "No corresponding column type could be found" This was for a Text Varchar column which had the size 255 characters.
The other fields were all Integer (integer) fields.
Any ideas? Is it something to do with Sql not recognising Text VarChar? If so, what datatypes do I need to choose in my Base table?
I dragged the table definition into the MySql database, although it warned me that column types were not recognised (I changed them to what I hoped were recognisable types and the definition imported and looked ok) I was able to type a row of data into it. But when I tried to append the actual data from Base, I got a warning "No corresponding column type could be found" This was for a Text Varchar column which had the size 255 characters.
The other fields were all Integer (integer) fields.
Any ideas? Is it something to do with Sql not recognising Text VarChar? If so, what datatypes do I need to choose in my Base table?