Euro symbol becomes '¿'
185335Mar 19 2004 — edited Aug 3 2006Problem:
We have a problem storing the Euro symbol in the database.
Please help.
thanks,
Anthonie
Description:
1) The euro symbol is correctly displayed in the generated application when the symbol is correctly stored in the database.
2) In standalone OC4J:
a) We insert an euro symbol and press the 'save' button
b) We now see in stead of the euro symbol a normal question mark ('?')
c) After requerying the data an upside down question mark is displayed ('¿').
When accessing the database using Toad, we see this last symbol stored in the DB.
3) In standalone OC4J:
a) We insert an euro symbol into the DB using Toad.
b) We retrieve the relevant record in the generated application
c) We make NO changes and press the 'save' button
d) We get a message stating that the changes were successfully saved
e) We now see in stead of the euro symbol a normal question mark ('?')
f) After a requerying the data an upside down question mark is displayed ('¿').
4) When using the 9iAS:
a) We insert an euro symbol and press the 'save' button
b) We no see the upside down question mark right away.When accessing the database using Toad, we see this last symbol stored in the DB.
5) When using the 9iAS:
a) We insert an euro symbol into the DB using Toad.
b) We retrieve the relevant record in the generated application
c) We make NO changes and press the 'save' button
d) We get a message stating that the changes were successfully saved
e) An upside down question mark is displayed ('¿').
6) The browser (IE 6.0) uses the 'Western European (Windows)' encoding, however: in the source of the generated html pages we see the following code:
<html dir="ltr" lang="en-GB">
<head>
<link rel="stylesheet" charset="UTF-8" .....
Configuration:
* MVC-framework, UIX pages,
using Single Sign On; setting the language/country
settings to en-GB
Application is generated with settings nl-NL
* Charset in database (8.1.7.0.0): WE8MSWIN1252
Charset in registry (used by Toad): WE8MSWIN1252
Charset in iAS infrastructure: WE8MSWIN1252
Charset in iAS midtier: WE8MSWIN1252
Charset used according to browser: Western European
(Windows)
Charset set in PageBroker: windows-1252
Charset in generated HTML page: UTF-8
* JHeadstart Runtime Version: 9.0.3 Production Build: 58
MVC Framework Version: 2.0 - Production Version
Build: 84