Skip to Content
author's profile photo Former Member
Former Member

How to solve 10427 error when trying to retrieve unicode data from HANA.

Hi experts,

I am testing ODBC Driver of HANA,odbc connection is ok.But when I try to get unicode data,the 10427 error was encountered,details

information are :


General error ;-10427 Conversion of Parameter/Column [2] from data type VARCHAR1 to ASCII failed


my sql is quite simple: select userid,username from users,column username include Chinese character.

Can anyone help on this,thanks in advanced.

YingQi Xiao

error.png (4.7 kB)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Dec 30, 2014 at 06:24 AM

    Hi Kelvin,

    Please check the below link



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member


      Situtation is not exact same as the URL you posted.We found the issue is due to the ODBC driver has problem when dealing utf8 character.The solution is modify the column type from varchar to nvarchar,everything is ok.

      Thanks for your help.