SAP Knowledge Base Article - Preview

3006236 - VarChar datatype inconsistency between ASE & IQ - SAP IQ

Symptom

VarChar datatype inconsistency between ASE & IQ:

SELECT @@VERSION ServerVersion, CAST('Sécur' AS VARCHAR(5)) CastToVarChar,datalength('Sécur') DataLength,Len('Sécur') CharLen

ServerVersion| CastToVarChar | DataLength | CharLen
SAP IQ/16.1.040.1372/13871/P/SP04.04 | Sécu| 6|5

=====

SELECT @@VERSION ServerVersion, CAST('Sécur' AS VARCHAR(5)) CastToVarChar,datalength('Sécur') DataLength,Len('Sécur') CharLen

ServerVersion | CastToVarChar | DataLength | CharLen
Adaptive Server Enterprise/16.0 SP03 PL08| | Sécur | 5,5


Read more...

Environment

SAP IQ 16.1 SP04 PL04

Product

SAP IQ 16.1

Keywords

varchar collation charset character set DATALENGTH LEN UTF8 ISO_1 multi-byte characters truncated non-english , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

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

Search for additional results

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