Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

How to find the possible 'NLS_CHARACTERSET' when we know a special char mapped to a hex code

qihua wu

2006-06-06


Hi, every on!

Our database is of UTF8, and someday somebody insert letter like "f?r" with a wrong client NLS_LANG, so when I query that row, the result messed up. I find that three letter stored as "102,195,182" in the database, Can we know what NLS_LANG did the guy use when he insert that data?


Thanks


Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2?/min or less.
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.