Re: Changing Codepage on database move
Hello Richard.
Thanks for your answer.
I'll check the program.
Best regards from Hannover, Germany.
Dirk
richard.harnden@googlemail.com schrieb:
> emmermacher@hotmail.com wrote:
>
> > Hello.
> >
> > I'm preparing a move of my database (IDS 7.30 on HP-UX 10.20) to a new
> > server (IDS 9.40 on SUSE Linux 8.2). On both system we're using isql.
> > The data on my old machine are using the Codepage 437. Here is no
> > DBLOCAL set. On the new machine I want to use DBLOCALE=de_de.8859-1 and
> > CLIENTLOCALE=de_de.8859.1
> > With Copdepage 437 (7-bit) the german Umlaute are brackets i.e. [ = Ä.
> > When I unload data toa file I have to change the brackets to Umlaute
> > via a MS-Word Macro. With the new machine I want to use the right CP
> > here. I tried to exchange the brackets on the .unl files with Word. But
> > on dbimport I have conversion error numeric to text. With files with
> > changing anything, the dbimport works.
> > I exchanged
> > [ = Ä ( Ä )
> > ] = Ü ( Ü )
> > \\\\ = Ö ( Ö )
> > { = ä ( ä )
> > } = ü ( ü )
> > | = ö ( ö )
> > ~ = ß ( ß )
> >
> >
> > This is .profile on my new server:
> >
> > export INFORMIXDIR=/home/informix
> > export INFORMIXSERVER=mega_shm> > export
> > PATH=$PATH:$INFORMIXDIR/bin:/$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql
> > export LD_LIBRARY_PATH=/$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql> > export DBMONEY=,
> > export DBDATE=DMY4.> > export DBLOCALE=de_DE.8859-1
> > export CLIENTLOCALE=de_de.8859-1
> > export DBDELIMITER=#
> > export DBPATH=/prog/NTB_DB> >
> > Is there a method to change the codepage without problems?
> >
>
> I'd take a look at iconv <http://www.gnu.org/software/libiconv/>;
>
> --
> rh