2725495 - How to modify NCHAR collation settings in an IQ database - SAP IQ

You want to modify NCHAR collation settings displayed during creating an IQ database.

$ cat create_database.sql
CREATE DATABASE         '/IQ/DEV/LN16SP1006.db'
BLANK PADDING           ON
CASE                    RESPECT
COLLATION               'EUC_KOREA'
IQ PATH                 '/IQ/IQDEV/IQ_SYSTEM_MAIN.iq'
IQ SIZE                 1000
TEMPORARY PATH          '/IQ/IQDEV/IQ_SYSTEM_TEMP.iqtmp'
TEMPORARY SIZE          1000
IQ PAGE SIZE            262144
JAVA                    ON
JCONNECT                ON
MESSAGE PATH            '/IQ/IQMSG/LN16SP1006.iqmsg'
;

$ dbisql -c dsn=demo -nogui create_database.sql
CHAR collation sequence:  EUC_KOREA(CaseSensitivity=Respect)
CHAR character set encoding:  EUC-KR
NCHAR collation sequence:  UCA(CaseSensitivity=UpperFirst;AccentSensitivity=Respect;PunctuationSensitivity=Primary)
NCHAR character set encoding:  UTF-8
Database is not encrypted
Creating system tables
Creating system views
Setting option values
Execution time: 5.936 seconds
$

All SAP IQ versions

"NCHAR"; "NCHAR collation"; "UCA"; "AccentSensitivity"; "PunctuationSensitivity"; "NCHAR character set"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To