[firebird-support] Why this returns string truncate??

[Fabiano]

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?



[Non-text portions of this message have been removed]



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

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

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/