开发者

oracle: what is the oracle equivalent data type for COMMENT?

开发者 https://www.devze.com 2023-02-10 17:32 出处:网络
What is the datatype in oracle i should be using to store comment boxes? I w开发者_如何学编程as going to use LONG but it only allows one. Or should I just use VARCHAR2 and set it really large?What is

What is the datatype in oracle i should be using to store comment boxes? I w开发者_如何学编程as going to use LONG but it only allows one. Or should I just use VARCHAR2 and set it really large?


What is the longest comment you want to be able to support?

If your comments are less than 4000 bytes in length, you can use a VARCHAR2(4000). If your comments are longer than 4000 bytes in length, you can use a CLOB. A CLOB can store any character data supported by your database character set.

0

精彩评论

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