Skip to Content
avatar image
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

  • Get RSS Feed

1 Answer

  • Dec 30, 2014 at 06:24 AM

    Hi Kelvin,

    Please check the below link

    Regards,

    Jituda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Jituda,

      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.

      Kelvin