on 12-29-2014 9:22 AM
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
Hi All ,
These data type conversion errors may occur due to different reasons, as explained in some documents from the knowledge base (including scenario with chinese and japanese characters) :
2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments
3219943 -10427 Conversion of parameter/column (*) from data type NVARCHAR to ASCII failed
2673779 - Error -10427 when run SQL from hdbsql with Chinese or Japanese characters
You should take a consistency check on the affected table(s) used in the conversion to ensure there is no corruption on table level.
2116157- FAQ: SAP HANA Consistency Checks and Corruptions
Kind Regards
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kelvin,
Can you please provide me steps, how you resolved this.
we are facing same issue in SAP data service.
Thanks
Prameel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.