Gustavo, (I'm brazillian)

what is the character set of this field (VALIDADE) ?

maybee it is none and this Char set don´t accepts characters with accent.



Jean Paul Lopes
Sócio-Gerente

TSA Tecnologia Sistemas e Automação Ltda.
http://www.tsa-sistemas.com.br
Rua Cel Sarmento, 1699 / 101
94010-031 - Gravataí - RS
Fone/Fax: 51 488.3608 / 3042.6084

Membro da Comunidade Firebird de Língua Portuguesa
http://www.comunidade-firebird.org
Fazendo o Firebird falar português
jean.lopes@...

----- Original Message -----
From: "Gustavo Moda (Yahoo)" <luisgustavomoda@...>
To: <firebird-php@yahoogroups.com>
Sent: Wednesday, February 18, 2004 8:48 AM
Subject: [firebird-php] Problem with character international in store
procedure


> Fellows,
>
> When I run select below:
>
> SELECT
> ' até ' || DATETOSTR(VALIDADE_ATE, '%d/%m/%Y')
> FROM TABELA
>
> It works fine.
>
> When I run the command below in store procedure:
> VALIDADE = ' até ' || DATETOSTR(VALIDADE_ATE, '%d/%m/%Y')
>
> Result this error:
> "arithmetic exception, numeric overflow, or string truncation -
> Cannot transliterate character between character sets"
>
> I replace the character "É" to "E" in store procedure and it works fine.
>
> Could someone help me?
> I'd appreciated that.
>
> Sorry my poor English, I'm studding! :D
>
>
> Thanks.
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>