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.
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.
Joined: May 28, 2013
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.
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.