开发者

PL/SQL data type support for size greater than NVarchar2

开发者 https://www.devze.com 2023-03-31 11:04 出处:网络
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 mo

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 the CHUNK parameter of LOB storage) of character data. If the tablespaces in your database are of standard block size, and if you have used the default value of the CHUNK parameter of LOB storage when creating a LOB 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消