ketanco
06 Jul 2008, 11:15 AM
Hi,
I exported my existing database as sql format to a text file. I started a new database, and my goal was to copy the contents of the existing to the new one, so I imported that sql text file to the new database.
It imported all the tables and everything, but strangely, for the columns which contains long texts, it omits the part after a ' or " sign.
For example if the original text is like this:
This car is red. This is Joe's red car...
It imports only this for that cell:
This car is red. This is Joe
So the part of the whole text after a ' or " sign is gone....
Now what might be the problem here?
I exported my existing database as sql format to a text file. I started a new database, and my goal was to copy the contents of the existing to the new one, so I imported that sql text file to the new database.
It imported all the tables and everything, but strangely, for the columns which contains long texts, it omits the part after a ' or " sign.
For example if the original text is like this:
This car is red. This is Joe's red car...
It imports only this for that cell:
This car is red. This is Joe
So the part of the whole text after a ' or " sign is gone....
Now what might be the problem here?