"Searching encoded strings in SQL Server 2000?"

Sorting It All Out : Searching encoded strings in SQL Server 2000?

"A guy named Michael (who is not me) asked the following question in the Suggestion Box:
Is it possible to search an NVARCHAR column containing string data encoded in a number of different encoding types?

I'm dealing with iso-8859-15, big5, utf-8, iso-8859-1, us-ascii encoding types and need to search the strings for keywords using either full-text indexing or the LIKE clause.

The quick answer is no. ..."

As I am now playing in Unicode (aka non-ASCII) land I found this interesting...