Hi, i'm working with NONE charset database (RDB$DATABASE). The natural
language of data is spanish and the client, for example Marathon SQL,
use ISO8859_1.

I can query for all field in separted sentences:

select tipo,direccion,numero,piso,puerta from direcciones OK

But i can't do that:

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

In the last sentence, if i delete all character inserted all is OK.

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

The last test, insert the special characters to the end of sentence:

select tipo || direccion || numero || piso || puerta || '/ ' || '
' from direccion OK.

I have a view defined with this sentence and select is OK. The problem
is that i don want to use this view inside procedure code.




Any hints?.
Thank in advanced.
Danny