Re: DBI/ODBC Truncating Long Fields

Is this happening for all columns, or just particular ones?

Your database will truncate FULL_DESCRIPTION at 4000 characters:

FULL_DESCRIPTION - VARCHAR2(4000)
[download]

Cheers.

BazB.

If the information in this post is inaccurate, or just plain wrong, don't just downvote - please post explaining what's wrong.
That way everyone learns.

Comment on Re: DBI/ODBC Truncating Long Fields Download Code

Replies are listed 'Best First'.
Re: Re: DBI/ODBC Truncating Long Fields by LostS (Friar) on Jan 23, 2003 at 17:26 UTC
No the Database call was truncating the entries after like 255 char's or something... as for the DB truncating that is up to the DB people... not me... I just needed to make sure I grabed all the data they spit at me... Thank you :) ----------------------- Billy S. Slinar Hardtail - Hand of Dane Datal Ephialtes - Guildless RallosZek.Net Admin/WebMaster `perl -e '$cat = "cat"; if ($cat =~ /\143\x61\x74/) { print "Its a cat! +\n"; } else { print "Thats a dog\n"; } print "\n";'` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: DBI/ODBC Truncating Long Fields
by LostS (Friar) on Jan 23, 2003 at 17:26 UTC

perl -e '$cat = "cat"; if ($cat =~ /\143\x61\x74/) { print "Its a cat!
+\n"; } else { print "Thats a dog\n"; } print "\n";'
[download]

[reply]
[d/l]