I have a DB from a user of my software, with a lot of accented (French) characters in it. The character set is UTF8.

When I do:

SELECT DISTINCT f_GenerateSndxIndex(column) FROM table

I get a "Malformed String" error.

However, doing that select without DISTINCT, or without the f_GenerateSndxIndex but with DISTINCT, both work!

Any bright ideas?

I considered trying the same function from FreeAdHocUDF, but it seems like you have to install so many extra files with that, that it's off-putting to even try it (and would unduly increase the size of my app).

Thanks.