Kbase P129004: Unable to display Euro symbol via SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/5/2010 |
|
Status: Unverified
SYMPTOM(s):
Unable to display Euro symbol via SQL-92
Cannot display Euro (?) symbol via SQL-92 utilities such as Crystal Reports
Problem occurs for both JDBC and ODBC connections
Euro symbol is displayed correctly in ABL application
Starting the database with -cpinternal 1252 has no effect
Setting SQL_CLIENT_CHARSET=1252 has no effect
FACT(s) (Environment):
Database code-page is ISO8859-1
ABL application started with -cpinternal 1252 -cpstream 1252
Euro symbol was displayed as expected in Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
CHANGE:
Upgraded to OpenEdge 10.x
CAUSE:
This is expected behaviour. The SQL Engine does not take -cpinternal into account and instead just uses the database code-page. The ISO8859-1 code-page does not contain the Euro symbol.
FIX:
Use a code-page that contains the Euro symbol (such as 1252 or IBM858) for the database