Sorry Adriano, the message appear incomplete. I paste de complete
message here.

-----------------------------

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.

------------------------------

Thanks
Danny

Adriano dos Santos Fernandes escribió:

>
> Danny Garcia Hernandez escreveu:
> > 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:
> >
> Why?
>
> Adriano
>
>