sorting hebrew in access

[Or]

I have my site hosted in the US and I use access as the database.
when I try to run a simple query like:
welect * from names order by surname
the results are not correctly orders according to the hebrew alphabet.

any ideas on how to fix this problem ?

[Tom van Stiphout]

Re: sorting hebrew in access

On 8 Sep 2006 23:52:56 -0700, "Or" <ori@ganpooh.co mwrote:

This looks promising:
Tools Options General New Database Sort Order

-Tom.

>I have my site hosted in the US and I use access as the database.
>when I try to run a simple query like:
>welect * from names order by surname
>the results are not correctly orders according to the hebrew alphabet.
>
>any ideas on how to fix this problem ?