Solved

italian charset problem

Posted on 2002-06-20
12
457 Views
Last Modified: 2011-08-18
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
0
Comment
Question by:k_murli_krishna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 16

Expert Comment

by:heyhey_
ID: 7097957
what code do you use for extracting single VARCHAR (Italian encoded) value  from the database ?
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7100112
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
 
LVL 16

Expert Comment

by:heyhey_
ID: 7101340
does it diplay correctly of user manually changes Encoding (from View/Encoding menu) ?
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7101575
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
 
LVL 16

Expert Comment

by:heyhey_
ID: 7101610
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
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7116033
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
 
LVL 16

Expert Comment

by:heyhey_
ID: 7121145
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
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7122352
heyhey, you win, i lose.
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7122357
tommorow i will post the exact problem by getting back to the colleague who got it to me in the first place
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7123971
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
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 7123988
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
 
LVL 16

Accepted Solution

by:
heyhey_ earned 100 total points
ID: 7124010
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

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how to install java on RHEL image on EC2 4 57
Chrome and Firefox Java 5 68
Bot application - advice 3 63
running on tomcat not jboss eap 7.0 3 33
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question