J
JC, Fredericksburg, VA
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.
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.