Re: DBI, blobs, and strings longer than 256 chars

Stephen Roach wrote: > That was the solution which I resorted to but I really wanted to use > the TEXT type. My data source is flat files ported from another > system. > > Actually, the problems started when I tried to get some test data into > my TEXT column. Couln't convert from CHAR or VARCHAR. Couldn't get a > 4GL screen to do the insert and dbload didn't do it either. > > Any ideas? Blobs will load via dbload, just have a pipe symbol after the final character of the blob field, and escape any new lines within the blob field by ending each of those lines with a backslash (\\). -- ______________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA | | Any opinions I state are my own and not necessarily of my employer | |____________________________________________________________________|