Ignored characters

[John Baima]

When indexing text, Access ignores characters in the Greek Extended
range (\u1Fxx). Is there anyway to make Access (and SQL Server!)
handle these characters? Are their other character ranges ignored by
Access? Thanks

-John

[Michael \(michka\) Kaplan [MS]]

Version of Access? Sort order (collation) of the database?
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"John Baima" <jo**@REMOVEME.silvershot.com> wrote in message
news:3o********************************@4ax.com...

When indexing text, Access ignores characters in the Greek Extended
range (\u1Fxx). Is there anyway to make Access (and SQL Server!)
handle these characters? Are their other character ranges ignored by
Access? Thanks

-John

[John Baima]

"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote:

Version of Access? Sort order (collation) of the database?
Access 2002. General Sort order. The column may have several other
languages besides Greek.

Try:

u1F41 u03B4 u03BF u1F76
and
u03B4 u1F7B u03BF
and
u03B4 u03BF

They all get indexed as the same string in Access and SQL Server.


"John Baima" <jo**@REMOVEME.silvershot.com> wrote in message
news:3o********************************@4ax.com... When indexing text, Access ignores characters in the Greek Extended
range (\u1Fxx). Is there anyway to make Access (and SQL Server!)
handle these characters? Are their other character ranges ignored by
Access? Thanks

-John