Re: nls problem ?

"V.Salvador" <nospam_vsalvador@deistersoft.com> writes: >NLS is a complex internationalization data arquitecture. It's not obious to >change a NLS database configuration. We have requested to Informix a utility >to change the NLS capabilities of a D.B. but, until now, there are only a >solution, dbexport the database a dbimport it with a diferent NLS sequence. >P.E. >DB_LOCALE=es_es.8859-1 export DBNLS >CLIENT_LOCALE=en_us.8859-1 export CLIENT LOCALE>dbexport mydabatase -o /export >DB_LOCALE=en_us.8859-1 export DB_LOCALE>dbimport mydatabase -i /export our database has a size >1GB (in summa) i guess i dbexport would take a lot of time and space (* 2 to import the database). I agree there is alot to do for informix i frankly dont undertand why they mixed the internal representation and output. hopefully they solve this problem in near future. walter >Walter Harms wrote: >> The database is created with german settings. we have moved it to >> installation with no settings at all (to get the default ones). Does >> informix store languages dependent information in its datafiles ? >> we have some strange effects we dont understand else. >> -- ----- "What we really need is a lateral molecular rectifier." "What on Earth's that?" "Not on Earth, unfortunately!" -----