Re: Novice question about non-English characters in data

"Brian Smith" <bsmith@sausage.com.au> wrote: :Hi there, :My name is Brian Smith and I'm a senior programmer at Sausage Software. :We've run into a last minute quirk with our Informix database; we've found :that it has trouble storing non-english characters such as ', ' etc...Our :database has to hold a lot of international language data and this needs to :be fixed ASAP. I'm not the DBA, but I'm helping him out with this search. : :If you can help please reply to me. All help is GREATLY appreciated. I've :already search the FAQ and didn't find anything to answer this. : :Thanks in advance ! It depends on what version of what engine you have. Prior to ver. 7.2 you need to set up NLS (national language support), from 7.2 on it's GLS (Global Language Support). GLS is documented in a separate manual you can download from http://www.informix.com/answers/answers/english/pubs.htm The GLS manual should also be one of those that came with your engine. For other information you may also want to start at: http://www.informix.com/wgs If you have earlier engines NLS is described in one of the manuals you should have. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org