Subject Re: [firebird-support] Re: SELECT distinct with f_GenerateSndxIndex from FreeUDFLib fails
Author Ann Harrison
On Sun, Jun 3, 2012 at 2:55 PM, dancooperstock <dcoops@...> wrote:

> OK, I gave up and wrote my own UDF. It ended up having exactly the same
> problem as the one in FreeUDFLib, namely that if the first character, which
> gets copied directly into the result string, is accented, you get
> "Malformed String" when it is returned.
>
> This is despite the fact that in my first draft for testing, all the code
> did was copy the first 5 char from the input to the result string, and that
> worked with no errors, with the same input with an accented first char! So
> I don't understand why the real code, which copies in the first char then
> calculates 3 more digits based on further consonants in the input, causes
> that error.
>

Sigh. Was the first letter of the string you looked at a capital E with an
accent grave? If so, my recollection is that in UFT8, that's a two-byte
character. So, are you copying bytes or are you copying characters?

Good luck,

Ann


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