Subject | substr(s,m,n) caused arithmetic exception, numeric overflow, or string truncation |
---|---|
Author | vmddtech vmdd |
Post date | 2003-12-19T22:07:03Z |
Background: FB 1.5 RC6, Windows 2000.
I have table news where txt is a column defined as
varchar(255).
When issuing the SQL:
select substr(txt,1,2) from news;
Then, I get the mentioned error. I am certain that
all txt rows contains enough text (20 characters or
more).
Ben
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
I have table news where txt is a column defined as
varchar(255).
When issuing the SQL:
select substr(txt,1,2) from news;
Then, I get the mentioned error. I am certain that
all txt rows contains enough text (20 characters or
more).
Ben
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree