Re: long data type

In article <38C210B7.DA8E066C_at_cableone.net>,   "Robert W. Stanford" <stanford_at_cableone.net> wrote:
> I am using a long data type , and it was my understanding that it
 could
> take up to 2 gigs of character data......
>
> using cold fusion to write to the db, we error out with "string
 literal
> too long"....on just 7k.
>
> suggestions?

are you sure its 7k? It should be either 2,000 or 4,000 bytes if you are using a character string constant in a SQL query.

To see why and find out how to not have this issue (the answer is "use bind variables") see http://osi.oracle.com/~tkyte/Misc/LargeStrings.html
>
>

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.