PDA

View Full Version : Omits the text after quotes while importing..Why?



ketanco
06 Jul 2008, 10: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?