Subject Re: [firebird-support] Embedded Firebird and Character Fields
Author Nikolay Ivanchev
Yestrday we had the same problem
works with type4 driver, not with embedded
What we found is that DB was not created with DEFAULT CHARSET
when we recreated the database, everything was fine
Niki




> I have a table that is being accessed using an Embedded Server via
> ADO. It works fine except I get the following error when I perform a
> simple query with a condition on a Char or varchar field.
>
> eg SELECT * FROM MyTable Where MyCharField = '8'
> or SELECT * FROM MyTable Where MyCharField LIKE '8'
> etc
>
> MyCharField is definitely Char or VarChar and not a BLOB
>
> I'm using FB1.5 RC6
>
> Fetch failed.
> SQLCODE=-802:
> arithmetic exception, numeric overflow, or string truncation
> Implementation of text subtype 53 not located.
> IBCODE=isc_arith_execpt.
>
> Any Ideas?
> Peter Gore
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>