aspose file tools*
The moose likes Other Big Data and the fly likes Not able to fetch french charcter from teradata Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Other Big Data
Bookmark "Not able to fetch french charcter from teradata" Watch "Not able to fetch french charcter from teradata" New topic
Author

Not able to fetch french charcter from teradata

Bhawna Gupta
Greenhorn

Joined: May 28, 2013
Posts: 27
Hi All,

I am facing one issue regarding Teradata i.e when i am fetching data from teradata and data contain french character then french character displayed in junk form .In teradata DB , data with french character stored properly. Data is stored into teradata DB through batch process . I tried to figure out. But not getting any progress.
Anybody who know this answer please help me.
Thanks in advance.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18991
    
    8

I don't know anything about what you are doing there, but I do know this: There are two steps involved in the process. First: Get the data from Teradata. Second: Display the data somewhere using some unknown process.

So there are two possible sources of your problem. You seem to have already decided that "First" is the source, but it's possible that the problem is really in "Second". So I suggest you look at both. Or if you get stuck, you might consider providing some information about what you are doing. Read our FAQ page TellTheDetails (<-- follow that link) to see what I mean.
Bhawna Gupta
Greenhorn

Joined: May 28, 2013
Posts: 27
Hi,

Sorry Paul for not clear my point at this form.
Actually , i am fetching data from teredata at service level then displaying through jsp page. But when data fetched from teradata DB . I checked at that point of time.I got junk charcter instead of french data.Due to which jsp page also showing junk character.
Not able to share code at this form.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10289
    
168

How are you fetching that data from the database? Are proper character encodings setup at relevant places?

[My Blog] [JavaRanch Journal]
Bhawna Gupta
Greenhorn

Joined: May 28, 2013
Posts: 27
Hi Jaikiran,

On Service level , there is one Hibernate Query through which data is fetched from Teredata . On Jsp level, proper encoding style is used. But my concerned to fetch the data from teredata. Is there any mapping or property that we should add in our project regarding Teredata for encoding style?

One thing which am not clear . When batch process run to store the data in Teredata then all french character will store . If there is any encoding problem then french character will not store properly. So,why we are facing this issue only on fetching.

Teredata is new for me. So, please help me .
Thanks in advance.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10289
    
168

What does your persistence.xml/hibernate.cfg.xml look like? Is there any character encoding property set on the connection, through that configuration?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Not able to fetch french charcter from teradata