MySQL Forums
Forum List  »  Sybase

Re: Data truncated while loading
Posted by: Xavier Manach
Date: December 21, 2009 09:27AM

Hi

Did you try with ENCLOSED BY '"'
and

and this format :
3 | 194 | 1 | "Need Quote" | "per Rich's specifications in phone msg of 9/20/2001. Lump at 23, in between payments and retirment payments, 3 options using $240,000 per child" | 2001-09-25 00:00:00.0 | "N/A" | "Yes" | null | null | 1 | "Normal" | null

ESCAPED BY can help you if you have " in your texts.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Good Luck.

Options: ReplyQuote


Subject
Views
Written By
Posted
8204
November 10, 2009 01:44AM
Re: Data truncated while loading
4983
December 21, 2009 09:27AM
5055
January 04, 2010 07:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.