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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
