Hi,

> > ISO-8859-1 does contain the Pound Sterling sign (but not, B.T.W. the
> > Euro sign)
> >
> > > My database has all it's varchar fields using the ISO8859_1 character
> > > set. I've now found out that this cannot handle the UK sterling '£'
> > > sign - it gives:
> > >
> > > ISC ERROR CODE:335544321
> > >
> > > ISC ERROR MESSAGE:
> > > arithmetic exception, numeric overflow, or string truncation
> > > Cannot transliterate character between character sets
> > >
> >
> > So something else in your setup must be wrong and we'll need
> > more info about what you are doing.
>
> Thanks Peter...
>
> To eliminate my app, I've used using Database Workbench and I can look
> at the database properties which gives:

So do I ;-)

> Character Set: ISO8859_1
> ODS Version: 10.1
> Version: WI-V6.3.0.4290 Firebird 1.5
>
> Creating a simple table with an integer ID and a varchar field (len16,
> Charset ISO8859_1, Collation ISO8859_1 ), I then execute:
>
> insert into TestTable( TT_ID, TT_NOTES) values(100, '£')
>
> and I then get the above error. I am running this on Win2ksp4 and the
> server is running (FB v1.5 Final SS) remotely on another Win2ksp4 machine.

It works fine here, do make sure you are connecting with the ISO8859_1
characterset as well. Right click the database in the Enterprise Manager
and select "Registration Properties" - make sure it's on ISO8859_1

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com