2
(click on this box to dismiss)
How to interpret the differences between these two manual pages?
I have mostly based jOOQ's CUBRID data type support to what is available here:
http://www.cubrid.org/manual/841/en/Data%20Types
Unfortunately, that was not the best choice for the jOOQ source code generator, as it is reading db_attribute, which returns data types as defined here:
http://www.cubrid.org/manual/841/en/_db_attribute
There is some confusion about a couple of data types. How to interpret this?
- The OBJECT, OID types aren't listed in the "Data Types" page
- What is the "_db_attribute" ELO type?
- "Data Types" mentions a "BIT VARYING" type, but "_db_attribute" returns "VARBIT". Is this a synonym?
- "Data Types" mentions various synonyms for what seems to be the SQL standard "NVARCHAR". "NVARCHAR", however, doesn't seem to exist, but "_db_attribute" returns "VARNCHAR" instead. Which synonyms work?
In the cases where there is confusion, I'm also interested in which type/name I should use when casting
link
comment (0)
accepted answer
asked last year
![[Level:3]](http://www.cubrid.org/modules/point/icons/default/3.gif "Rank: 3/30, reputation score 63 (26% completed for the next level)"){kind=icon}
lukaseder63
1
Answer
1
- OID type is not documented since it's not an actual type, the correct type would be OBJECT but this also is not an actual type. OBJECT type is used when you're defining a column type as being a class type.
- ELO type has been replaced by BLOB and CLOB. It is there only for historical reasons.
- VARBIT is a synonym for BIT VARYING. The SQL syntax in CUBRID only understands BIT VARYING (this is what you should use for CAST).
- NCHAR VARYING is the supported name for VARNCHAR/NVARCHAR type in CUBRID SQL syntax.
![[Level:7]](http://www.cubrid.org/modules/point/icons/default/7.gif "Rank: 7/30, reputation score 491 (91% completed for the next level)"){kind=icon}
ginarrbrikasked last year
viewed 559 times