Hi Adriano, i using FB 1.5.1, in this revision this problem is fixed.

Remember that i can select from columns data in ISO8859_1 charset. The
problem is when i try to concatenate this data using || operator and
special characters. In a adreess table i have separated field that
conform (all) the complete address. Right now, i have a process that
conform the complete address folowing some rulesand insert it Av/
Liberty # 100) into one column in other table.

select tipo || direccion || numero || piso || puerta from direccion [ OK.]


select tipo || '/ ' || direccion || ' ' || numero || ' ' || piso || ' '
|| puerta from direccion [ FAIL (direccion field contain a Ó character).]

Thanks
Danny







Adriano dos Santos Fernandes escribió:

>
> Danny Garcia Hernandez escreveu:
> > Sorry, i'm getting this error message.
> >
> > ERROR: Cannot transliterate character between character sets.
> >
> What version are you using?
>
> AFAIR, such type of problem was fixed in one of the 1.5 point releases,
> with the patch changing NONE charset behavior.
>
> Adriano
>
>