sorting with entries in multiple languages

[Julian]

Hi. I was wondering if there is a way of sorting some records in Access 97
which contains a mixture of entries in different languages. For example, I
have 3 records in English, and 3 records in Chinese charset. The problem is
that the records in Chinese are not grouped together and jumbled together
with the English charset records. I've tried sorting them in Access 2000 and
it looks fine, but I need this in Access 97. Thanks.

 

[John Nurick]

Hi Julian,

I don't think many people here have experience of dual-byte versions of
Access 97. Possibly you need to change the collating order of the
database; see Help on the DAO CompactDatabase method. You may do better
to ask in a Chinese-language forum (e.g. microsoft.public.cn.access).

Otherwise, all I can think of is writing a function that examines the
contents of the field and returns a modified string that gives the sort
order you want (e.g. if it's in a Western characterset prefix with "zzz"
and if it's in Chinese prefix with "$$$"). Then use this function in the
ORDER BY clause in your queries.