Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Unique/Distinct on Japenese text returns incorrect results

Discussion in 'Information Technology' started by excel_hari@yahoo.com, Jul 28, 2006.

  1. excel_hari@yahoo.com

    Expand Collapse


    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

    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
    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?


Share This Page