Re: Help w/intl characters

You have run into the typical problem of software developed in the US. They don't understand that there may be more characters than in 7 bit ascii. The only whay Informix have arround this problem is to use NLS if you are on 7.1x or GLS if you are on 7.2x - unfortunate but true. You can insert 8 bit characters by putting them in a variable and inserting that. However they can't occur in a literal string in an insert statement in any product from Informix. (The limitation is probably implemented in the database server itself.) The problem of using NLS or GLS is of course all the trouble with finding out about and implementing locale support on whatever OS you are working. Not an easy task, but RTFM on it. Of course you do gain some additional benefits from NLS/GLS in support for proper sort orders and the like. ordenar@impsat1.com.ar (Oscar Goldes) wrote: :Hello, :I am using Informix OnLine 7 over SCO Unix. I get a -202 error (invalid :character embedded in SQL string) whenever I try to insert a register :containing the character "n tilde" (decimal 165) or any accented vowel. :However, if I load them from a file with the "load from" command, there is :no error message and subsequent selects show the characters OK. I am using :dbaccess from a TinyTerm emulator. :The type of the field in which we try to insert is varchar. :The same problem appears running from a PowerBuilder app. over I-NET :Any help will be gratly appreciated :Thanks in advance. :-- Oscar Goldes :-- ogolde@orden.cl 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