Translating French characters from a Windows UI character set to an Oracle database using PROCOBOL

0 Likes

This article describes how to translate French Characters between a Windows UI screen Character set and the Oracle Database Character Set.

Problem:

Using a graphical interface on Windows, the data you recover is not stored properly on your Oracle database using ProCOBOL, and you are losing special characters like "éàù".

Resolution:

Set up the following environmental variable before executing the runtime:

Export NLS_LANG=FRENCH_FRANCE.WE8MSWIN1252

This tells the PROCOBOL code you have in your application that the IO with the COBOL program will be made with this Character set and that the data should be transformed before being stored on the database (to whichever Character set the database is set at). Your UI will now handle the standard Windows French characters properly and translate them when communicating with the Database.

Old KB# 14259
Comment List
Anonymous
Related Discussions
Recommended