> problems. For instance, I don't know if the convert() function would make
> sense then. (Does it even make sense now?)
Yes. Consider you have UNICODE database and want to sort by French or
whatever LATIN locale.
SELECT * FROM t1 ORDER BY convert(text_column,'LATIN1');
would be the only way to accomplish that.
--
Tatsuo Ishii