What's you connection charset ?

You must use the same charset.

see you


Em 13/12/2011 15:33, Fabiano escreveu:

> 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
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>