well this error is because you might have given the field as text and when ' or " sign comes it takes like the string is completed there. so you need to add slash before the symbol.
R U PHP programmer? Srikanth --- On Sun, 6/7/08, Tedit kap <[EMAIL PROTECTED]> wrote: From: Tedit kap <[EMAIL PROTECTED]> Subject: [php_mysql] database import To: [email protected] Date: Sunday, 6 July, 2008, 8:43 PM 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? From Chandigarh to Chennai - find friends all over India. Go to http://in.promos.yahoo.com/groups/citygroups/ [Non-text portions of this message have been removed]
