PL/SQL has data type NVARCHAR2(size) where the size is 32767 bytes; equivalent to 4095 records.
Now, what data type should i give as an alternative to NVARCHAR2 that could s开发者_如何学JAVAupport more than 4k records? I have a gridview in asp.net that doesn't support paging. Which datatype is most suitable to support more than 4095 records?
Is this just text? You could use CLOB
:
The
CLOB
data type stores single-byte and multibyte character data. Both fixed-width and variable-width character sets are supported, and both use the database character set.CLOB
objects can store up to (4 gigabytes -1) * (the value of theCHUNK
parameter ofLOB
storage) of character data. If the tablespaces in your database are of standard block size, and if you have used the default value of theCHUNK
parameter ofLOB
storage when creating aLOB
column, then this is equivalent to (4 gigabytes - 1) * (database block size).
You can check same page for other types (BLOB
, NCLOB
) for storing large amounts of data.
精彩评论