Re: Change Database Locale

> I have the same problem. > > the only way is export the database without set dblocale and clientlocale. > (if the actual locale is the default (en_us.819 or 8859-1 is the same). > Then set the clientlocale='en_us.819 and dblocale='new locale'.(or the > reverse? I don't remember..try it with an littlle table) > > Import the database. > > This is the best way, because informix translate the codes betwen actual to > news, and is not nessesari to set dbmoney or others. > > After this , your database is in new locale, but you can configure clients > with some others locales whit set BDLOCALE='locale of database' and > CLIENTLOCALE= 'the locale that client wants to use'. Informix translate the > codes. > > Don't forget that each time you create a database, he takes the locale you > have set in your DBLOCALE or CLIENTLOCALE. if not set, he take the default > en_us.819. > > Don`t try to modify dirctly the codes in the systables tabid 90-91, this may > cause an coruption of database, and after this you can't drop it.I have testet > this, and the only way to drop the corupted database is to edit directly the > database to correct the codes. > > Remember the 7.X informix uses GLS. the olds variables (dbmoney, nls, dblang ) > function well but hare not nessesaris.You can work only with > DBLOCALE,CLIENTLOCALE.