SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-49
Character Set
Character Set
This attribute determines the default for the character set:
Attribute Setting
INFER_CHARSET When set to ON, the parser does not consider the
character set of literals. However, the binder decides
the character set depending on the context. The default
value for this attribute is OFF for MXCI and ON for
ODBC/MX and JDBC/MX.
For example:
>>create table infchar(i CHAR(10)
character set ucs2);
--- SQL operation complete.
>>insert into infchar values('abc');
*** ERROR[4039] Column I is of type
CHAR(10) CHARACTER SET UCS2,
incompatible with the value's type,
CHAR(3) CHARACTER SET ISO88591.