DISTINCT not working - varchar

[Kay C Lan]

Hi,

simple SQL query:

SELECT DISTINCT category FROM products

returns every single row, all category returned multiple times.

Tested in VStudio 4.5 and same result.

Searching the List I see Christian reported getting Errors 1 year ago when
doing DISTINCT on varchar fields. My  field is varchar but I don't get an
error I just get exactly the same result as if I'd done:

SELECT category FROM products

Did a quick test on unsigned short and date field and got correct results.

Is there some trick to doing DISTINCT on varchar fields?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20100620/cd73f06d/attachment.html>