Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Full width characters

595071May 27 2008 — edited May 28 2008
I have a web application in which users can type any data. During testing I noticed that I can change the input language and select Full Width Japanese or Half Width Japanese as my input language. I typed in the english letter 'A' using these both and was surprised to see that I had to use linguistic comparison to retrieve the two records having the letter 'A' .

I am interested in understanding this more. I read the article NLS_Lang and Webservers explained(Note:229786.1). As per that, any thing typed in a web application is of the character set of the ANSI code page, which in my case is 1252. Then the browser converts this to the character set of the web server, in my case UTF-8, which once again gets converted to the database character set based on NLS_Lang.

Are the characters in full width and Half width truly different characters (encoding). Are there any articles that I can read to understand these characters more.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2008
Added on May 27 2008
4 comments
2,836 views