|Tags in TagTable|
I want an index of tag values that is INDIFFERENT to upper or lower case.
SELECT DISTINCT Tag FROM TagTable ORDER BY lower(Tag)
APPLE Apple mango Mango Peach peach
I want it to return three values. I don't care what case they are so long as they're listed only once.
I tried adding COLLATE to my statement with either DATABASE_DEFAULT or
SQL_Latin1_General_CP1_CI_AS or utf8_bin. All give me a ? as the result.