Re: sysmaster:sysdbslocale ??

Posted in 1999

Pons Roca, Isidre — Thu, 26 Aug 1999 11:01:21 +0200 — source: Informix-list mailing list archive (1991-1998)

samir BADAOUI wrote: 25 Aug 99, 14:10: > > > did any one know how informix fills the values of the field dbs_collate in > the table sysdbslocale for each database ??? Thi value depend from DB_LOCALE environemnt variable at the database create time. If fou don't have set this INFORMIX take en_US by default. To change it you do: Unload the database. drop the database. set DB_LOCALE variable to a desired value. create the database load all the data. A hard work :-(( Be fun. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------