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 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Statement/Type-Related Parameters

The following are parameters related to SQL statements and data types supported by CUBRID. The type and value range for each parameter are as follows:

Parameter Name

Type

Default Value

block_ddl_statement

bool

no

block_nowhere_statement

bool

no

compat_numeric_division_scale

bool

no

intl_mbs_support

bool

no

oracle_style_empty_string

bool

no

block_ddl_statement

block_ddl_statement is a parameter that restricts the execution of DDL (Data Definition Language) statements by the client. If the parameter is configured to no, the given client is allowed to execute DDL statements. If it is configured to yes, the client is not permitted to execute DDL statements. The default value is no.

block_nowhere_statement

block_nowhere_statement is a parameter that restricts the execution of UPDATE/DELETE statements without a condition clause (WHERE) by the client. If the parameter is configured to no, the given client is allowed to execute UPDATE/DELETE statements without a condition clause. If it is configured to yes, the client is not permitted to execute UPDATE/DELETE statements without a condition clause. The default value is no.

compat_numeric_division_scale

compat_numeric_division_scale is a parameter that configures the scale to be displayed in the result (quotient) of a division operation. If the parameter is configured to no, the scale of the quotient is 9; if it is configured to yes, the scale is determined by that of the operand. The default value is no.

intl_mbs_support

intl_mbs_support is a parameter that specifies whether or not to support multibyte character set. If the parameter is configured to no, a multibyte character set is not allowed; if it is configured to yes, a multibyte character set is allowed. To improve performance, it is recommended to configure the intl_mbs_support parameter to no and use alphabets for table and column names because operation cost for supporting multibyte character set is high.

oracle_style_empty_string

oracle_style_empty_string is a parameter that improves compatibility with other DBMS (Database Management Systems) and specifies whether or not to process empty strings as NULL as in Oracle DBMS. If the oracle_style_empty_string parameter is configured to no, the character string is processed as a valid string; if it is configured to yes, the empty string is processed as NULL. Therefore, if the oracle_style_empty_string parameter is configured to yes, the empty string is processed as NULL as in Oracle DBMS.