Thanks, Ann.

Unfortunately, I tried:

SELECT f_GenerateSndxIndex(_LATIN1 'ÉLISE') FROM rdb$database;

and it still gives the same error. ("_LATIN1" is clearly correct - "_LATIN_1" gives a message about unknown charset.)

--- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...> wrote:
>
> 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]
>