Re: Convert existing INFORMIX 10.x Database from en_US.819 to en_US.utf8

chetan.anand@gmail.com wrote: > Model-Bosch, Tilman wrote: > >>>chetan.anand@gmail.com wrote >>>Hi: >>>Calling ALL INFORMIX GURUS, how could I convert existing massive >>>database of close to 25 Million rows which is sitting as en_US.819 to >>>en_US.utf8 without export and import again. Any help on this is >> >>greatly >> >>>appreciated and THANKS IN ADVANCE FOR ALL >> >>export and import is the only way :-( >>in place change of the data is impossible. > > > Thanks, actually current database does contain only english character > set and I am planning to get non-english single byte character set, I > am just seeing looking at the huge data set, any quick win instead of > export / import. > > Rgds > Chetan > It might be possible to use by dbcopy utility to copy form the old database to the new one. The conversion should be automatic since the actual character codes are the same for the printable characters. Dbcopy is part of the package utils2_ak available for download from the IIUG Software Repository. Art S. Kagel