Re: Inserting a pound sign.

I 'm sorry, I'm puzzled and I don't understand. We can insert pound signs (#) ASCII ( 0x23 ) without any problem. We're using Informix 7.1 on an HP 9000. I don't know of a DB_LOCALE environment variable. Are you talking about the pound as in the British currency unit? If so, what about DBMONEY? I get some strange characters "2E" in the message below. Many thanks. Peter Wages EDS } } If you want to have a pound sign in an insert statement, the default (US) } locale won't do. You have to set DB_LOCALE appropriately at the time the } database is created. } ------- } } Brian Wilkins. } } In article <62ih3r$pc@cssun.mathcs.emory.edu>, davin_harvey@dsti.co.uk () } wrote: } } > How do I do this? When I use the insert into =2E=2E=2E values =2E= } > 2E=2E= } > and have=20 } > a pound sign (ASCII 0xa3) as part of the insert, it gives me a -202 } > :=20 } > An illegal character has been found=2E I've tried different locale } > s,=20 } > but no joy=2E } > =20 } > Online V7=2E22 on AIX V4=2E1=2E3=2E } > =20 } > Ta } > Davin } > } > ********************************************************************** } > DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco= } > 2Eu= } > k=20 } }