Re: Load data infile and text fields

2005-04-13 Thread sdotceci
@lists.mysql.com Subject: Re: Load data infile and text fields Date: Sun, 10 Apr 2005 02:32:28 +0200 Cc: [EMAIL PROTECTED] Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]: First of all I hope you can be patient for my english I'm working with data import into mysql from a txt file

Re: Load data infile and text fields

2005-04-09 Thread John Doe
Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]: First of all I hope you can be patient for my english I'm working with data import into mysql from a txt file. I'm using LOAD DATA INFILE command but I cannot correctly import a text column of 595 characters. I receive this (very

Re: Load data infile and text fields

2005-04-05 Thread sdotceci
@lists.mysql.com, [EMAIL PROTECTED] Subject: Re: Load data infile and text fields Date: Mon, 4 Apr 2005 15:52:06 -0400 Stefano, I'm copying this to the mailing list. I think it is a lot better if we have discussions of this kind on the mailing list so that others can also learn from them, either

Re: Load data infile and text fields

2005-04-04 Thread Gleb Paharenko
Hello. Do you use a VARCHAR type for that column? It's maximum length is limited to 255 characters. I think, switching to TEXT type could solve the problem. [EMAIL PROTECTED] wrote: First of all I hope you can be patient for my english I'm working with data import into mysql

Re: Load data infile and text fields

2005-04-04 Thread sdotceci
documents. Each record should have a single word file. I'd like to write a query (I hope without using api as php or other languages) that imports automatically all .doc files stored ina dir. Have any idea? Thanks Stefano -- Messaggio originale -- Subject: Re: Load data infile and text fields From

Re: Load data infile and text fields

2005-04-04 Thread Rhino
[EMAIL PROTECTED] Sent: Monday, April 04, 2005 12:24 PM Subject: Re: Load data infile and text fields Rhino, many thanks for your answer! My problem is that I need a filed with precision for a field of exactly 595 characters! Only text field type with precision is the char type but its limit is 256

Re: Load data infile and text fields

2005-04-04 Thread Michael Stassen
On Apr 4, 2005, at 3:52 PM, Rhino wrote: Stefano, I'm copying this to the mailing list. I think it is a lot better if we have discussions of this kind on the mailing list so that others can also learn from them, either now or in the future via the mailing list archive. I'm glad to hear that you

Load data infile and text fields

2005-04-02 Thread sdotceci
First of all I hope you can be patient for my english I'm working with data import into mysql from a txt file. I'm using LOAD DATA INFILE command but I cannot correctly import a text column of 595 characters. I receive this (very large) file from an external organization and this file is made

Re: Load data infile and text fields

2005-04-02 Thread Michael Dykman
What is the structure of the table you are importing to? you might have merely hit the natural limit of the column type. - michael dykman On Sat, 2005-04-02 at 06:51, [EMAIL PROTECTED] wrote: First of all I hope you can be patient for my english I'm working with data import into mysql

Re: Load data infile and text fields

2005-04-02 Thread Rhino
- Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, April 02, 2005 6:51 AM Subject: Load data infile and text fields First of all I hope you can be patient for my english I'm working with data import into mysql from a txt file. I'm using LOAD DATA