Access 2007 distinct queries on unicode text

Access 2007 distinct queries on unicode text - bug?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JC, Fredericksburg, VA - 23 Oct 2006 03:10 GMT

I have a table with unicode (Greek) text in it which I imported from a text
file. When I view the data I can see all the correct unicode characters
correctly.

I then did a distinct query, and I am missing a lot of my data - in fact, I
only get 23 results when I expected over 50.

I have the same problem with a new table that I am attempting to create.
When I attempt to instert a new unicode character, sometimes I get prompted
that this is a duplicate value - which it is not.

Is there a setting that I need to change? I have tried with both unicode
compression off and on.

Reply to this Message

Allen Browne - 23 Oct 2006 16:50 GMT

That's interesting, JC.

Couple of other things that might be contributing factors:

a) JET does indeed have trouble handling DISTINCT, even aside from any
Unicode issues. The results are inconsistent, depending on whether the field
has a unique index or not. More info:
http://allenbrowne.com/bug-12.html

b) Is this a Text field, or a Memo field?
Memo fields are handled differently in any de-duplication, including
DISTINCT. More info:
http://allenbrowne.com/ser-63.html

Your issue may well be different from those I am aware of, as I don't do
much with non-English languages, but thought you might appreciate knowing
about those issues anyway.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a table with unicode (Greek) text in it which I imported from a text
> file. When I view the data I can see all the correct unicode characters
[quoted text clipped - 11 lines]
> Is there a setting that I need to change? I have tried with both unicode
> compression off and on.

Reply to this Message