Problème with accented characters

Djou2424

We are importing and exporting accented characters for one of our client.
We are having problem when exporting it to a text file.

We are already using the ASCIItoANSI and ANSItoASCII functions.
It works fine with some characters like É
But for others, like È, it doesn't.
As an example, exporting the string "JOSÉE BELLEROSE ÈÉÀ" results in "JOSÉE BELLEROSE ßÉÚ"

As you can see, the É character is converted properly, but not the È and the À

Any idea what we are doing wrong?

kriki

Probably nothing.

Probably the conversion of that character is not foreseen in the functions.
You have to find out from which ASCII to which ASCII it must go and add those values to the conversion strings.

Djou2424

And how do I find that conversion exactly?

Savatage

Djou2424 wrote:

We are already using the ASCIItoANSI and ANSItoASCII functions.

Which one are you using?
http://www.mibuso.com/dlinfo.asp?FileID=1096

ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø׃áíóúñѪº¿®ÁÀÊËÈÍÎÏÌÓßÔÒÚÛÙ'
'€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©µ¶·ÒÓÔÖ×ØÞàáâãéêë

or
http://mibuso.com/dlinfo.asp?FileID=287

'€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©ª«¬­®¯ÝÝÝÝݵ¶·¸ÝÝ++½¾++--+-+ÆÇ++--Ý-
'ÏÐÑÒÓÔiÖ×Ø++Ý_ÝÞîàáâãäåæçèéêëìíîïðñ=óôõö÷øùúûüýÝÿ';

Djou2424

I'm using the Ansi-Ascii converter.
http://www.mibuso.com/dlinfo.asp?FileID=287

But in Navision, some characters are replaced by white squares or double vertical lines

Savatage

We used this solution see here:
viewtopic.php?f=7&t=25554

and finally arrived at:

To make this unnecessary in Navision.
Start->Run->regedit
Go to [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage]
And change the "OEMCP" value to "1252" (or the same as ACP)
Reboot

Changing to 1252 - really helped us with special characters.

Djou2424

It's working, thank you very much.

Savatage

The downside is you have to change it on all machines

Djou2424

I know, I'll contact our client and propose the solution to them, we will see if they agree to change it on all machine or not.