由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - long and CLOB.. any differences?
相关主题
Oracle long数据类型 行转列的问题question for webdb guru
Help need on writing data to Oracle CLOB!Help about mysql
Oracle / DB2 问题SQL问题求救!!
问一个SQL LOADER BLOB的问题有关m# sql server text字段类型一问
Does MS SQL 7 support SQL3 Datatype?Questions about building a database(Maybe ACCESS?)
Is "Dim mydb as database" a user-defined datatypethe most stupid question
how to write this query, need help !!My SQL question: auto increment
questionimage datatype in sql server
相关话题的讨论汇总
话题: long话题: clob话题: support话题: oracle话题: any
进入Database版参与讨论
1 (共1页)
b****e
发帖数: 1275
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*********t
发帖数: 4
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

1 (共1页)
进入Database版参与讨论
相关主题
image datatype in sql serverDoes MS SQL 7 support SQL3 Datatype?
请大侠帮帮忙!SQL server error问题。Is "Dim mydb as database" a user-defined datatype
Oracle char AND varchar2 datatype question.how to write this query, need help !!
Oracle Group and Index questionquestion
Oracle long数据类型 行转列的问题question for webdb guru
Help need on writing data to Oracle CLOB!Help about mysql
Oracle / DB2 问题SQL问题求救!!
问一个SQL LOADER BLOB的问题有关m# sql server text字段类型一问
相关话题的讨论汇总
话题: long话题: clob话题: support话题: oracle话题: any