Skip to Content
author's profile photo
Former Member

The symbol u00BE read from a database by ABAP changes to u00F3

I have a table where a column contains the 3/4 mark (¾). When I list the table with SQL or MSAccess, the 3/4 mark is visible as expected. However, when ABAP reads this same table, the 3/4 mark is changed to ó. If I view the table in SE16, same result.

I would chalk it up to a font issue but when the ABAP writes the row to a new table, the change is permanent. Reviewing the row ABAP inserted shows that the ¾ was changed permanently to ó. Even MSAccess and SQL show this new character in place of the old when looking at the inserted row.

What is causing this change? It is obviously changed during the SELECT into ABAP and stays changed from that point forward. I need to wither figure out how to make the correct code pull into ABAP or how to convert it to the correct code on the insert into the new table.

Thanks for the help.

Crew Reynolds

Daydots

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 14, 2004 at 07:36 AM

    I would guess that you have a bad mixture of code pages. What Lanuage are you using in SAP and what code page is the data written in this database table?.

    SAP internally uses character set 1100 which is ISO Latin-1 for English. Microsoft has a slightly different code page for Latin-1 they call 1252. However checking the code page map in SAP, the oacute (ó) should be hex F3 whereas the threequarters (¾) is hex BE. This matches the hex values that I have for Windows 1252. The following is a website where you check out the hex values for many different character sets: http://www.i18nguy.com/unicode/codepages.html#msftwindows. The SAP values can be viewed from SPAD.

    If you do have an odd mixture of code pages, you might have to force the translation. The following would be the example ABAP code:

    translate wa_itab1 from code page '1404'.

    You would just have to find the SAP code page that matches what your data is encoded in.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Jung

      I'll see what Microsoft can tell me. The code page might be in the SQLServer config. I'm reading a Z-table from the same database that my SAP is running on. I just fill it with an external source.

      Thanks for the leads. I'll run with it.