Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 

Using OIDs and Collections

ODBC is designed for relational DBMSs. Therefore, CUBRID ODBC does not support some object-oriented features such as CUBRID OIDs and collections. It is because CUBRID is an object-relational DBMS that integrates relational and object-oriented data models.

Using OIDs

Because the CUBRID ODBC driver considers an OID as a string (char(32)), the INSERT, UPDATE and DELETE statements containing OIDs can be used as follows. The OID string should be used with single quotes (''). The domain of the member attribute in the following example is the same as the OID.

insert into foo(member) values('@12|34|56')

delete from foo where member = '@12|34|56'

update foo set age = age + 1 where member = '@12|34|56'

Using Collections

Collection types : SET, MULTISET and SEQUENCE are supported. The CUBRID ODBC driver considers a collection as a string (longvarchar). You can obtain a collection by separating each element in the SELECT statement using commas in braces as with "{value_1, value_2, ...value_n}."

Note If a string longer than defined size in a column is inserted(INSERT) or updated(UPDATE), the string will be truncated.