dcsimg
German characters are not stored and retrieved properly
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   SANKAR_MOULICK
Posted On:   Friday, January 24, 2003 03:54 AM

I want to maintain some data in Germancharacters I am using ISO-8859-1 charset cotent type in JSP Databace NLS language set up is WE8ISO8859P1 . I am able to type German characters in Input contorls ie either textarea or Textbox where we can able to see same as german charcters. eg: Musterstraße gemäß But After retrieving it is not the same what I have inserted. For all special characters it is showing like Musterstraýe gemýý If I insert through insert script and give a select query I am able to see perfect german characters. Provided NLS_LANG should be german. ie American_America.WE8ISO8859P1. If any body knows about this please help me out.    More>>

I want to maintain some data in Germancharacters
I am using ISO-8859-1 charset cotent type in JSP
Databace NLS language set up is WE8ISO8859P1 .
I am able to type German characters in Input contorls ie either textarea or Textbox where we can able to see same as german charcters.
eg:
Musterstraße
gemäß

But After retrieving it is not the same what I have inserted. For all special characters it is showing like
Musterstraýe
gemýý

If I insert through insert script and give a select query I am able to see perfect german characters. Provided NLS_LANG should be german. ie American_America.WE8ISO8859P1.

If any body knows about this please help me out.

Regards,
Sankar.

   <<Less

Re: German characters are not stored and retrieved properly

Posted By:   Joe_Millionaire  
Posted On:   Friday, January 24, 2003 06:59 AM

You need to use the UTF8 encoding. ISO-8859-1 only handles the english language.

Create an UTF8 encoded database.

Get the latest oracle jdbc drivers.

Set response.setContentType("text/html; charset=UTF-8")

Set request.setCharacterEncoding("UTF-8")

If you do any String.getBytes() calls they must be changed to:

String.getBytes("UTF-8")

Do not use the javascript function escape() instead use encodeURIComponent() or encodeURI()

I18N in a nutshell

About | Sitemap | Contact