SAP Knowledge Base Article - Preview

2567071 - German Umlaut chars Polish national chars incorrectly handled with UTF8BIN - SAP IQ 

Symptom



UTF8BIN collation doesn't handle non-English chars, such as German umlaut chars and Polish national chars correctly.


    

  • The function ASCII on an umlaut char or Polish national chars returns NULL.
    • 

  • UPPER/UCASE and LOWER/LCASE functions on an umlaut char or on Polish national chars or on any non-English char don't convert the chars to upper/lower case.
    • 



            

         

           
              Read more...
           
        

      



Environment



   

    

  • SAP IQ 16.1
    • 

  • SAP IQ 16.0
    • 








Product



  SAP IQ 16.0 ; SAP IQ 16.1





Keywords



   
 
collation ; UTF8 ; UTF8BIN ; german ; polish, characters ; upper ; lower ; ascii ; ucase ; lcase; accent; compare ; sortkey ; to_nchar ; 811930 ; , 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.