Re: GLS converting Inf 7.2

Johan wrote: > Hi! > > Could anyone please help me to convert my database > with a default locale of US english to Swedish? > I have read the GLS guide and the Migration guide (which states > that you can change locales on a database but doesn't give > any examples). > I have a 7.22 server running on Solaris 2.6. > I have tried to update the systables but with no luck. > Do I have to unload the database, create a new one > with SERVER_LOCALE defined and then reload it? > I would like to do it on the fly, if it's possible. > That's about what you have to do. 1) Backup your database (you never know ...) 2) dbexport your database 3) drop it 4) set environment varibles DB_LOCALE and CLIENT_LOCALE (I do not set SERVER_LOCALE as it seems to concern only naming conventions in the Unix File System) 5) create your database (best without logging) 6) dbimport 7) change logging and backup > > Any ideas? > Thanks! > > -- > > Johan Wikstr'm > > Is it weird in here, or is it just me? Good luck for this awful job (I had to do it already 4 times). -- Helmut Leininger Bull AG / Vienna Unix Support Email: helmut.leininger@bull.de This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.