Hive-ODBC error in encoding

[#1]

i am using hortonworks ODBC-Hive to connect from php page to hive , the problem is to search not English character especially Arabic character i made change in the hortonworks.hiveodbc.ini to value << DriverManagerEncoding=UTF-8> , what further edit i can do in configuration of odbc driver and when i query the result i have this value

\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a

[#2]

Did you checked this document here ?

[#3 · Accepted solution]

Yes, i read it , but it only mention the edit in hortonworks.hiveodbc.ini , and i made this edit but nothing changes

@Amine Hallam , please what else can i do to make it work ;

[#4]

hi @Amine Hallam , thanks for your response but i solved after 4 days searching . the problem was in the configuration of the apache server . i change the configuration of etc/apache2/envar ,

comment << EXPORT LNAG = C >>

then

uncomment ./etc/default/local

i hope it help any