I use charset WIN_1252 for Portuguese characters.

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Alexandre Benson Smith
Enviada em: terça-feira, 13 de dezembro de 2011 15:06
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Why this returns string truncate??

Em 13/12/2011 09:32, Fabiano escreveu:

> I have this situation:
>
>
>
> CREATE TABLE TESTE (TXT VARCHAR(100));
>
>
>
> insert into TESTE(TXT) values ('MECƒNICA');
>
>
>
> This simple select return “Arithmetic overflow or division by zero has
> occurred. Arithmetic exception, numeric overflow, or string truncation.
> String right truncation.”
>
>
>
> select UPPER(TXT) from TESTE
>
>
>
> Tested with FB 2.5.1 and 2.5.0.
>
> Why it occurs?
>
>
>

Try to use charset ISO8859_1 or Win_1252



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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links