italian charset problem

Background:

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.

Issue:

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)

Observation:

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.

Example:

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.

An offline suggestion was to put name value pairs in HTML/JHTML being returned to browser to solve the problem.

--- k_murli_krishna
LVL 17
k_murli_krishnaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
heyhey_Connect With a Mentor Commented:
so

1. you generate plain text file that uses Italian charset
2. you display this text inside some HTML page.
3. user sees garbage

right ?

if .html page downloaded on the user side (save it and examine it manually) contains correct Italian symbols, this 'problem' can be solved with some HTML code.

if .html page does not contain correct Italian symbols, that there is some problem with your server side code that generates it.
0
 
heyhey_Commented:
what code do you use for extracting single VARCHAR (Italian encoded) value  from the database ?
0
 
k_murli_krishnaAuthor Commented:
we use UTL_FILE package of oracle to extract flat file(.txt or .sql) but how this is converted to HTML file, I am not sure since it occurs at onsite in US. But ultimately it is displayed in browser to see some bad italian characters. What i would basically like to know is what content we have to add to HTML file to make the browser display a particular locales language.

--- k_murli_krishna
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
heyhey_Commented:
does it diplay correctly of user manually changes Encoding (from View/Encoding menu) ?
0
 
k_murli_krishnaAuthor Commented:
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)

0
 
heyhey_Commented:
ok so:

you use UTL_FILE package of oracle to extract text info and then you generate HTML with that info

1. does it diplay correctly of user manually changes Encoding to Italian (from View/Encoding menu) ?
1. does it diplay correctly of user manually changes Encoding to UTF8 (from View/Encoding menu) ?
0
 
k_murli_krishnaAuthor Commented:
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. So view --> encoding menu is set to UTF-8 in browser.

0
 
heyhey_Commented:
so WHAT EXACTLY IS THE PROBELM.

when you etract info from database to FLAT FILE, how do the  symbols look like ? are they in Italian encoding ? or UTF-8 encoding ? send this text file to some Italian and ask him to open in in Notepad and check if all symbols look correctly.


can you give me URL for download of such file.
0
 
k_murli_krishnaAuthor Commented:
heyhey, you win, i lose.
0
 
k_murli_krishnaAuthor Commented:
tommorow i will post the exact problem by getting back to the colleague who got it to me in the first place
0
 
k_murli_krishnaAuthor Commented:
heyhey: the problem was with GDS adapter and not front, middle or back end. I would like it if you can elaborate on charsets of browsers and java.
0
 
k_murli_krishnaAuthor Commented:
heyhey: what i mean is how to work with charsets in browser, HTML and java i.e. what settings in browser and what code in HTML and java files is required to make the browser understand that italian chaset is being used.
0
All Courses

From novice to tech pro — start learning today.