Re: connect multilingual database

Posted in 2004

roger huang — 25 Mar 2004 17:22:08 -0800 — source: Usenet: comp.databases.informix

Pravin Kedia <kedia@us.ibm.com> wrote in message news:<c3u7s1$7f6$1@terabinaries.xmission.com>... > 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, I can't see "set locale"statment in all of IDS 9.4 manuals,but there is a statement "set collation" which is change collation order. Is that what you mean? What I want is the command or anyway can make connect two different locale database in the same session. thank in advance. > > 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