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
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.