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]
