SAP Knowledge Base Article - Preview

2725495 - Is it possible to modify NCHAR collation settings of an IQ database ?

Symptom

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
$


Read more...

Environment

All SAP IQ versions

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

"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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.