Changing Codepage on database move
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_shmexport
PATH=$PATH:$INFORMIXDIR/bin:/$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql
export LD_LIBRARY_PATH=/$INFORMIXDIR/lib:$INFORMIXDIR/lib/esqlexport 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?
Thanks in advance for your help.
Best regards.
Dirk Emmermacher
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