Re: INSERT 8bit chars

Nils Myklebust said >What language are you using? >The problem is that you can't insert 8 bit characters as part of >litteral strings without seting up GLS support. If you are using >Informix 4GL this isn't supported until ver. 7.2 however. This version >is only available by now for a small set of platforms. > >I have a request in with Informix to find a solution to this for us >using SCO Open Server ver. 5.0.x. >If someone know of a solution I would be extremely happy to hear about >it. I can think of two possibles off hand. The first is to use UTF-7 representations and hack the I/O routines to {en,de}code at some point. The second, 4GL specific, is to move to QueriX which is UTF-8 aware (although your engine compatibility may vary...). Even with QueriX there are, or were, problems on SCO OpenServer 5 which may affect things other than QueriX since it appears to be related to ctype tables and the multibyte character functions. I came up with a solution that replaced the mb*() functions with dumb ones that only did simple 8bit characters rather than the full UTF-8 gamut (*all* our forms have 8bit characters since we use an IBMPC character set for line drawing characters :-) ). I don't know if newer versions of QueriX or SCO solve the multibyte problems fully. Informix should realise that *not* having multinational language capabilities is a *BIG* problem with the on going European unification. Lots of companies that thought they were single language/country are discovering different... Mike -- .----------------------------------------------------------------------. | Mike Jagdis | Internet: mailto:mike@roan.co.uk | | Roan Technology Ltd. | | | 54A Peach Street, Wokingham | Telephone: +44 118 989 0403 |