To: [EMAIL PROTECTED]
>To: mysql@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 en
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 (v
ino" <[EMAIL PROTECTED]>
>To: "mysql" ,
> <[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
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
--
From: <[EMAIL PROTECTED]>
To: "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 te
lot
of little msword 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: L
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 f
Stefano,
The behaviour you are describing is normal, assuming that the column in your
MySQL table is defined as CHAR(255) or VARCHAR(255).
You didn't say which version of MySQL you are using. However, unless you are
using MySQL 5.0.3 or later, 255 is the largest size available for a CHAR or
VARCH
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 f
