We have an Italian Site setup on dynamo 5.1.1 with patch2 . The backend is Oracle 8.1.6 and the character set on the backend is UTF-8.
When we are trying to extract the users registered through the italian site out of the database into a flat file on unix box, the italian character set that are
coming is funny i.e. garbage! (this we are able to notice by opening this generated flat file in the browser and viewing it in UTF-8 encoding)
Through the dynamo administration (browser) interface , having the browser encoding set to UTF-8 , if we are querying the database, the records being displayed on the screen are correct.
This is the "italian city" that appears when we try to view the flat file (with extracted records) on the browser in UTF-8: CantÃ¹
When we run the query (from the browser admin screen having the encoding to UTF-8) to pull out the city we get it as Cantù (This is the correct city name)
We are using UTL_FILE package for extraction work. Some settings in init.ora OR database configuration OR registry OR environment variables need to be set?
Would really appreciate if you could help out in understanding why this is occuring.
Giving 100 points but more for good answers and points for expert for more than one good answer are not ruled out.