Topic: German characters are not stored and retrieved properly

German characters are not stored and retrieved properly

1 posts in topic

Flat View

Thread View

Older Post First | Reply to Topic

TOPIC ACTIONS:

Print Topic

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>>

Report | Quote This | Send private message | Reply | Print

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

Report | Quote This | Send private message | Reply | Print