Kbase P55248: Oracle DataServer: Any search (FIND .... WHERE) on a text field containing umlaut characters fail
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
Oracle 9i
SYMPTOM(s):
Any search on a text field containing umlaut characters fails (
FIND FIRST test WHERE name = "United" does not find the record
Oracle Database code page is WE8MSWIN1252
Oracle DataServer schema code page is IBM850
Progress schema holder code page is 1252
German installation of Windows
If a field is added in 4GL, umlaut characters are displayed incorrectly in SQL Plus or other Oracle tool.
CAUSE:
The code page on Oracle schema does not match code page for Oracle
FIX:
Change the code page for Oracle DataServer as follows:
Go to "Data Administration" and connect to your schema holder. Select Oracle database as working database. Go to "DataServer" - "Oracle Utilities" - "Change DataServer Schema Code Page" and change code page to 1252.
Warning! Please note that changing the code page will not convert data already in the database. If you have been writing data to database with a different code page, changing the code page can corrupt your data. If you have questions or doubts contact Progress Technical Support.