The maximum string size for varchar2 is 8000K. I suggest you use LOB (CLOB
or NCLOB) datatypes.


-----Original Message-----
From: Steffen Heil [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 12:40 PM
To: 'Tomcat Users List'
Subject: Strings in VARCHAR or BLOB

Hi

I need to store webpages in the database.
Until now I used BLOBs for this, but I think about switching to VARCHARs.

It would not be a problem to limit the content to say 10000 CHARs.
However I am using ISO8859_1. (I think this is a one-byte-charset?)

What would you recommend?

Regards,
  Steffen


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to