cancel
Showing results for 
Search instead for 
Did you mean: 

SAP-NLS w/ SAP-IQ - How to do CESU-8 on Linux UTF-8 server

Former Member
0 Kudos

The
SAP Netweaver BW:Implementation SAP-NLS with Sybase-IQ version 1.40  (April 2014) requires creation of DB using encoding CESU-8 and

collation CESU8BIN - see page 38). Neither of these are defined on our UTF-8 Linux server. When we attempt create the initial DB with CESU8 - it says

CHAR variables are CESU-8 and NCHAR are UTF-8. Is this correct?

Alternatively, must we rebuild our Linux server to operate in CESU-8 encoding? If so, how? The root of my question is note # 1737415 -- the other

documentation does not say this...

"The Sybase IQ server is installed.

Minimum required version is 15.4 ESD3 (15.4.0.3027).

Minimum required version for IQ 16.0 is 16.0 SP1 PL1 -(64 bit).

The code page of the server must be CESU-8 with collation/sort order CESU8BIN binary. Incorrect code pages cause data corruption and require a reinstallation of the IQ server.

We have installed IQ 16.0 SP03 (64-bit) on SUSE Unix 11  (Linux version 3.0.13-0.27-default).

Any suggestions.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Folks -

This appears to be my mis-understanding of the word 'server'.   The oss note 1737415 is referring to the Sybase IQ server rather than the underlying Linux Server build.   So,  when you build your NLS database and specify encoding = 'CESU8'  and collation='CESU8BIN' you get the following messages:

CHAR collation sequence: CESU8BIN

CHAR character set encoding: CESU-8

NCHAR collation sequence: UCA

NCHAR character set encoding: UTF-8

This appears to work -- the only confusion is the difference between CHAR and NCHAR.