Reply
New Contributor
Posts: 1
Registered: ‎07-03-2018

Excel adds � in front of results

Hi, not sure where to ask this question.  I'm simply an end-user, and dont understand the vast majority of the language used in these forums.  

 

When using excel to retrieve data from my database using Impala odbc driver, sometimes I get an extra � added in front of my string. 

 

When using HUE, this character is not there.

 

I tried running a select distinct on hue, I get 19 distinct values.  In excel, when I look at distinct values, I get 36.  Every string seems to get duplicated, with an extra � in front, except for NULL and (Blank) which do not get duplicated.

 

 

 

 

Announcements