long and CLOB.. any differences? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

long and CLOB.. any differences?

long and CLOB.. any differences?# Database - 数据库

b*e2002-04-09 07:04

1 楼

is there any difference between these two datatypes in oracle?
ibm websphere doesn't support long in CMP and suggested us to
convert to CLOB.. while weblogic says long support is part of
ejb 2.0 and that they support it.
so what's the difference? thanks

r*t2002-04-09 07:04

2 楼

Long is a legacy datatype of Oracle and being replaced by CLOB and BLOB. Long
can store up to 2G data and CLOB can store 4G. You can't use WHERE, GROUP BY,
DISTINCT and some other SQL clause for Long datatype. IMHO It's reasonable
that WAS doesn't provide backward compatibility to Long. But I am sure about
he ejb2.0 standard thingy, you sure the 'long' in it is the same thing of Long
in Oracle?

【在 b****e 的大作中提到】

: is there any difference between these two datatypes in oracle?
: ibm websphere doesn't support long in CMP and suggested us to
: convert to CLOB.. while weblogic says long support is part of
: ejb 2.0 and that they support it.
: so what's the difference? thanks