Unique/Distinct on Japenese text returns incorrect results

Hi,

I have a column which has names of companies in Japanese language in
Access from which I want unique entries only. If I run te following
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13756-unique-distinct-japenese-text-returns-incorrect.html
code

SELECT distinct [Company HW Ship To]
FROM sheet1
GROUP BY [Company HW Ship To];


Then 2 rows which have same japanese characters with only difference
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13756
being that one of them has an extra space in the starting gets treated
as same?

On the other hand If I put the same data in excel and use the advanced
filter with Unique entries only, then the 2 companies are treated
separately (Even the If function says that they are different)

Then, why is Access not giving correct results?

Regards,
HP
India

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!