DISTINCT not working - varchar

[Ivan Smahin]

Hello william,

Monday, June 21, 2010, 3:34:12 PM, you wrote:

> What is UTF-16BE ? That is what my database is set to.

BE is for Big Endian. Actually your db is UTF16 encoded but
created on Power Mac or something like this.

It would be showed as UTF-16LE if you create the db on Intel.
In other words - it's ok. :)

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com