Subject | Re: [firebird-support] Re: f_GenerateSndxIndex fails on accented characters |
---|---|
Author | Adriano dos Santos Fernandes |
Post date | 2008-07-07T16:12:05Z |
Dan Cooperstock escreveu:
You may also try to declare the UDF using explicit CSTRING(...)
CHARACTER SET NONE for the parameter and return value. Or maybe even
OCTETS for the return depending on what this UDF returns. Anyway, if the
UDF is not prepared to work with UTF8 you are going to have problems
with its result.
Adriano
> The database's default charset is also UTF8.This is what you should know for sure.
>
> I'm not sure how to determine how it is being encoded in the actual
> command. I'm currently running it from PowerBuilder, which uses
> Unicode.
>
You may also try to declare the UDF using explicit CSTRING(...)
CHARACTER SET NONE for the parameter and return value. Or maybe even
OCTETS for the return depending on what this UDF returns. Anyway, if the
UDF is not prepared to work with UTF8 you are going to have problems
with its result.
Adriano