Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Wednesday, 9 May 2012

Quotation marks changing in web forms, from being pasted from MS Word


Ever wondered why those funny quotes which Microsoft Word produces are translated as backwards ?. in web forms
If you write a quote in word, type something and then close with another quote, Word magically pairs the two quotes. One quote the right way up the other upside down. If you then copy & paste this text into an Oracle web form you may find, after saving, those wonderful quotes have turned into something else.

The problem here is the NLS_LANG parameter in the Application Server. A locale is a set of information addressing linguistic and cultural requirements that corresponds to a given language and country. Traditionally, the data associated with a locale provides support for formatting and parsing of dates, times, numbers, and currencies, etc. Providing current and correct locale data has historically been the responsibility of each platform owner or vendor, leading to inconsistencies and errors in locale data.
Setting the NLS_LANG environment parameter is the simplest way to specify locale behavior for Oracle software. It sets the language and territory used by the client application and the database server. It also indicates the client's character set, which corresponds to the character set for data to be entered or displayed by a client program.

If your Application Server is windows go to the windows registry (Type on run regedit) and locate the NLS_LANG parameter of the Oracle home the Application Server is using. check or change it as per the local Territory. I am using the English United State so my local setting is AMERICAN_AMERICA.AR8MSWIN1256
If you are using NLS_LANG = ENGLISH_UNITED KINGDOM.WE8ISO8859P1 then change it NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252

1 comments:

  1. This post is written up with a height of striking and involves decent information. Great insights web content specialist

    ReplyDelete