Check every application that interfaces with your database via ODBC, JDBC,
Perl DBI, etc. I've seen character set conversions add spaces between each
letter of a word for apps connecting via JDBC thin client. However the data
was in English, not French, so your mileage may vary.
-----Original Message-----
From: Sundaramoorthy Natarajan (GE Commercial Finance Consultant)
[mailto:oracledba-ezmlmshield-x37813836.[Email address protected]
Sent: Wednesday, June 29, 2005 2:07 PM
To: LazyDBA Discussion
Subject: Characterset
Hi,
We are in the process of changing database characterset from US7ASCII to
UTF8. I would like to know what kind of testing is required after the
conversion.
We are doing the conversion for stroing french character set...
What kind of testing is requrired from application and environment point of
view.
I have listed one which i can think off..
set ORACLE_SID=ge_tgwr1
set ORACLE_HOME=/oracle/app/oracle/product/8.1.7.4
set ORACLE_BASE=/oracle/app/oracle
set NLS_LANG=AMERICAN_AMERICA.UTF8
set ORA_NLS33=/oracle/app/oracle/product/8.1.7.4/ocommon/nls/admin/data
Thanks in advance
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**************************************************************************************
The information contained in this email is privileged and confidential information intended only for the use of the individual or entity named as recipient. If the reader is not the intended recipient, please be notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please do not disclose this communication to any other person. Please notify us immediately by telephone and return the original to us at the address indicated above. Thank you
Oracle LazyDBA home page