On Fri, Jun 1, 2012 at 12:20 PM, dancooperstock <dcoops@...> wrote:

>
> Second, the following also fails with "Malformed String":
>
> SELECT f_GenerateSndxIndex(column) FROM table ORDER BY 1
>
> If I omit the ORDER BY, it works fine.
>
> Also, for data without accents, it works fine.
>

Sigh. It looks as if the UDF doesn't handle UT8 character representation -
a very common limitation. You may be able to force the conversion from the
stored UTF8 to Latin1 (which I'd guess is the character set the UDF
expects) then back to UTF8 so the key generation works correctly. Firebird
generates sort keys for operations like ORDER BY, DISTINCT, and GROUP BY.

Check the release notes and documentation for hints on how to force
character set conversions.

Good luck,

Ann


[Non-text portions of this message have been removed]