Subject Which character set for the UK?
Author tickerboo2002
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

Which character set should I use for UK apps?

TIA

David

FBv1.5 Final, IBOv4.3Aa, BCBv5p1, Win2k