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

Re: Ignored characters

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" <john@REMOVEME. silvershot.com> wrote in message
news:3o6oovshjm 3ef4eplhnjovn0f o2tjs3d9c@4ax.c om...[color=blue]
> 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[/color]

[John Baima]

Re: Ignored characters

"Michael \(michka\) Kaplan [MS]" <michkap@online .microsoft.com> wrote:
[color=blue]
>Version of Access? Sort order (collation) of the database?[/color]

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" <john@REMOVEME. silvershot.com> wrote in message
news:3o6oovshjm 3ef4eplhnjovn0f o2tjs3d9c@4ax.c om...[color=blue]
> 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
>[/color]

-John