Re: Inserting a pound sign.

On Mon, 27 Oct 1997, 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 No, he said (and meant) pound signs, 0xa3. These are curly-L characters. Americans have a weird idea that the hash, sharp or octothorp character '#' is a pound. Well, maybe not completely weird; it's just part of the ongoing rejection of all things British following the American Revolution. :-))))) -- That's a really big smiley! } 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. Thoeretically, an en_gb.8859-1 locale should work for the British/UK locale, in the same way that en_us.8859-1 is the US equivalent. I've not done the tests to see whether it does or not. } } 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 ... values and have } } > a pound sign (ASCII 0xa3) as part of the insert, it gives me a -202: } } > An illegal character has been found. I've tried different locales, } } > but no joy. } } > } } > Online V7.22 on AIX V4.1.3. You could try examining the $INFORMIXDIR/gls/cm3/registry file for more ideas; in particular, it contains information on locale mappings on specific machines. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>