k_murli_krishna
asked on
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
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
what code do you use for extracting single VARCHAR (Italian encoded) value from the database ?
ASKER
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
--- k_murli_krishna
does it diplay correctly of user manually changes Encoding (from View/Encoding menu) ?
ASKER
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)
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)
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) ?
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) ?
ASKER
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.
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.
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.
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.
ASKER
heyhey, you win, i lose.
ASKER
tommorow i will post the exact problem by getting back to the colleague who got it to me in the first place
ASKER
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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.