Current location: Hot Scripts Forums » Other Discussions » Database » Omits the text after quotes while importing..Why?


Omits the text after quotes while importing..Why?

Reply
  #1 (permalink)  
Old 07-06-08, 12:02 PM
ketanco ketanco is offline
Newbie Coder
 
Join Date: Feb 2008
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Omits the text after quotes while importing..Why?

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?
Reply With Quote
  #2 (permalink)  
Old 07-10-08, 01:51 AM
dustin56 dustin56 is offline
Newbie Coder
 
Join Date: Jun 2008
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
The data in those fields is not properly escaped.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
text box with scroll bar silvermane CSS 7 01-16-09 03:03 AM
Search script improvement 9999 PHP 14 08-28-06 11:46 PM
Draggable Tables Ares JavaScript 10 08-03-06 06:55 AM
Need Your HelP! Loading Multiple External Text into Multiple Dynamic Text Fields Flash_Boi Flash & ActionScript 2 03-30-06 03:27 PM
picking random entries with a filter... Double selection problem dsumpter PHP 7 11-16-03 07:19 PM


All times are GMT -5. The time now is 05:03 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.