Re: Inserting a pound sign.

Yes, I mean pound as in the currency unit. As far as I am aware, the DB_LOCALE environment variable applies only in Informix version 7.2x. DBMONEY controls the display format of items of type MONEY only, not CHAR or VARCHAR. If you want a pound sign (ASCII 0xa3) you can't use the default (US) locale as it only allows so-called "printable" ASCII characters. '#' (0x23) is in the printable ASCII character set, but ''' (the currency symbol) isn't. Brian Wilkins. In article <6333ct$84m@cssun.mathcs.emory.edu>, pwages01@valos000.los.gsd.eds.com (Peter Wages) wrote: > 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 ab > out 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 t > he > } 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 lo > cale > } > 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=2 > Eco= > } > 2Eu= > } > k=20 > } > } > >