Michael, 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 char. I've tried with text type, but precision
were been ignored and my sql silently truncate it at 256 value. I solved
my problem creating a temp table with my field splitted in three char fields:
250+250+95, then I've rebuild each line with the function concat()!
Now I've another problem: after I've imported all txt files with a fully
automated query, I need to import into a table with a blob field, a 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: Load data infile and text fields
>From: Michael Dykman <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Cc: ""MySQL List"" <mysql@lists.mysql.com>
>Date: Sat, 02 Apr 2005 09:18:56 -0500
>
>
>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 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
>> without separators bitween fields. I know only the exact lenght of each
>> field. All is fine for fields < of 256 char, but I cannot import this
text
>> field of 595 characters. It's imported truncated at 255th character.
>> Help me please!
>> Stefano (osso)
>--
> - michael dykman
> - [EMAIL PROTECTED]
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to