Options

Problème with accented characters

Djou2424Djou2424 Member Posts: 76
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?

Comments

  • Options
    krikikriki Member, Moderator Posts: 9,098
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    Djou2424Djou2424 Member Posts: 76
    And how do I find that conversion exactly?
  • Options
    SavatageSavatage Member Posts: 7,142
    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Ö×Ø++Ý_ÝÞîàáâãäåæçèéêëìíîïðñ=óôõö÷øùúûüýÝÿ';
  • Options
    Djou2424Djou2424 Member Posts: 76
    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
  • Options
    SavatageSavatage Member Posts: 7,142
    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.
  • Options
    Djou2424Djou2424 Member Posts: 76
    It's working, thank you very much.
  • Options
    SavatageSavatage Member Posts: 7,142
    The downside is you have to change it on all machines :(
  • Options
    Djou2424Djou2424 Member Posts: 76
    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.
Sign In or Register to comment.