Because you use Windows, why don't you also use Windows character set ?
Win1252 has Pound, Euro, etc...

Ivan

----- Original Message -----
From: "tickerboo2002" <support@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, March 29, 2004 2:13 PM
Subject: [firebird-support] Re: Which character set for the UK?


> ISO-8859-1 does contain the Pound Sterling sign (but not, B.T.W. the
> Euro sign)
>
> --- In firebird-support@yahoogroups.com, "tickerboo2002" wrote:
> > 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:

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.