Re: connect multilingual database

Posted in 2004

Pravin Kedia — Thu, 25 Mar 2004 02:31:53 -0600 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 002EDD9B86256E62_= Content-Type: text/plain; charset="US-ASCII" Hi, IDS 9.4 Severs have introduce "set local" statment to support this. You should be able to swtich between database by changing the locale using the above statement in the same session. This is very much possible for locale which are codeset compatible. Please refer to IDS 9.40 manual for select local syntax. I do not know if you can do that in a 4GL though. Thanks, Pravin. owner-informix-list@iiug.org wrote on 03/24/2004 11:24:58 PM: > Hi all, > I have two database in two different locale environment. > One is set with DB_LOCALE=zh_cn.gb ( simplied Chinese for China ), > the other is set with DB_LOCALE=zh_tw.big5 ( traditional Chinese forTaiwan). > The problem is that I want to connect two database in 4gl program. > But IDS don't allow this , I need to connect DB in separate LOCALE > environments. > It means , > To connect DB in Taiwan, I need to set > DB_LOCALE=zh_tw.big5 > CLIENT_LOCALE=zh_tw.big5.> To connect DB in China, I need to set > DB_LOCALE=zh_cn.gb > CLIENT_LOCALE=zh_ch.gb.> How can I connect these two databases in 4gl program at the same time. > Anyone can help me out will be appreciated. --=_alternative 002EDD9B86256E62_= Content-Type: text/html; charset="US-ASCII" Hi, IDS 9.4 Severs have introduce "set local" statment to support this. You should be able to swtich between database by changing the locale using the above statement in the same session. This is very much possible for locale which are codeset compatible. Please refer to IDS 9.40 manual for select local syntax. I do not know if you can do that in a 4GL though. Thanks, Pravin. <tt>owner-informix-list@iiug.org wrote on 03/24/2004 11:24:58 PM: > Hi all, >   I have two database in two different locale environment. > One is set with DB_LOCALE=zh_cn.gb ( simplied Chinese for China ), > the other is set with DB_LOCALE=zh_tw.big5 ( traditional Chinese forTaiwan). > The problem is that I want to connect  two database in 4gl program. > But IDS don't allow this , I need to connect DB in separate LOCALE > environments. > It means , > To connect DB in Taiwan, I need to set >    DB_LOCALE=zh_tw.big5 >      CLIENT_LOCALE=zh_tw.big5. > To connect DB in China, I need to set >    DB_LOCALE=zh_cn.gb >    CLIENT_LOCALE=zh_ch.gb. > How can I connect these two databases in 4gl program at the same time. > Anyone can help me out will be appreciated. </tt> --=_alternative 002EDD9B86256E62_=-- sending to informix-list