For Programmers: Free Programming Magazines  


Home > Archive > Cobol > September 2006 > ACUODBC internation characters









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ACUODBC internation characters
bruno

2006-09-29, 6:55 pm

Hi !

Can anyone help me with this problem ?

- When I want to load the data from the ACUfiles in to f.e. Ms Excel,
special characters like =E8, =E9, =F6, ... are replaced by others. Reason
would be that AcuCocol works with the PC-8 charcter set, while windows
works with the ANSI-charcter set.

- In the 'ACUODBC advanced options' of the DSN-settings, I specified a
mapfile to solve this problem (the hex.dec. code for the client and the
DB are mentioned), but it still doesn't the conversion ...

f=2Ee. : the file mappings.txt contains the following lines:
0xFC 0x81
0xF6 0x94
0xD6 0x99
0xDC 0x9A

D6 hexadecimal =3D 214 decimal =3D =D6 in ANSI
99 hexadecimal =3D 153 decimal =3D =D6 in PC-8

Kind regards
Bruno

sgbojo@gmail.com

2006-09-29, 6:55 pm


bruno wrote:
> Hi !
>
> Can anyone help me with this problem ?
>
> - When I want to load the data from the ACUfiles in to f.e. Ms Excel,
> special characters like =E8, =E9, =F6, ... are replaced by others. Reason
> would be that AcuCocol works with the PC-8 charcter set, while windows
> works with the ANSI-charcter set.
>
> - In the 'ACUODBC advanced options' of the DSN-settings, I specified a
> mapfile to solve this problem (the hex.dec. code for the client and the
> DB are mentioned), but it still doesn't the conversion ...
>
> f.e. : the file mappings.txt contains the following lines:
> 0xFC 0x81
> 0xF6 0x94
> 0xD6 0x99
> 0xDC 0x9A
>
> D6 hexadecimal =3D 214 decimal =3D =D6 in ANSI
> 99 hexadecimal =3D 153 decimal =3D =D6 in PC-8
>


When setting up the DSN for AcuODBC there is an advanced option where
you can choose the ANSI character set. This should help.
> Kind regards
> Bruno


bruno

2006-09-29, 6:55 pm

It works !!!!!
Thanks !!!

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com