Re: Insert > 2499
From: Tim X <timx_at_nospam.dev.null>
Date: Mon, 26 Jul 2010 08:54:18 +1000
Message-ID: <87fwz7p3z9.fsf_at_puma.rapttech.com.au>
The Magnet <art_at_unsu.com> writes:
Date: Mon, 26 Jul 2010 08:54:18 +1000
Message-ID: <87fwz7p3z9.fsf_at_puma.rapttech.com.au>
The Magnet <art_at_unsu.com> writes:
> I have some insert statements with values that are > 2500 characters.
> I cannot make it a .CSV because the text has commas in it. It is a
> bunch of HTML. Any suggestions?
>
Why not just put quotes around the fields with commas in them?
I use external tables to load data with commas in the fields by doing this. The fields are not as large as yours, but it should work - though I don't know about column limitations and clobs in this context.
Tim
-- tcross (at) rapttech dot com dot auReceived on Sun Jul 25 2010 - 17:54:18 CDT