All 3 messages in topic - view as tree
From: emmermacher@hotmail.com - view profile
Date: Fri, Dec 1 2006 11:01 am
Email: "emmermac...@hotmail.com"
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?
Thanks in advance for your help.
Best regards.
Dirk Emmermacher
Reply » Rate this post: Text for clearing space
From: richard.harn...@googlemail.com - view profile
Date: Fri, Dec 1 2006 9:50 pm
Email: richard.harn...@googlemail.com
- Hide quoted text -
- Show quoted text -
emmermac...@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
--
rh
Reply » Rate this post: Text for clearing space
From: emmermacher@hotmail.com - view profile
Date: Tues, Dec 5 2006 9:01 am
Email: "emmermac...@hotmail.com"
Hello Richard.
Thanks for your answer.
I'll check the program.
Best regards from Hannover, Germany.
Dirk
richard.harn...@googlemail.com schrieb:
- Hide quoted text -
- Show quoted text -
> emmermac...@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
> --
> rh
Reply » Rate this post: Text for clearing space
End of messages
No comments:
Post a Comment