File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Not able to fetch french charcter from teradata

 
Bhawna Gupta
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20163
24
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How are you fetching that data from the database? Are proper character encodings setup at relevant places?
 
Bhawna Gupta
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What does your persistence.xml/hibernate.cfg.xml look like? Is there any character encoding property set on the connection, through that configuration?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic