Thank you very much for this useful information!
On 07/20/2010 10:19 AM, Dunbar, Norman (Capgemini) wrote: > Morning, > >>> My oracle database also has utf-8 format. I am not sure >>> where I am making mistakes. > Is it possible that your client connection to the database is not using > the correct NLS_LANG settings and is not actually getting the characters > in UTF8? > > Assuming you are on windows then the registry setting > HKLM/software/oracle/HOMEn/NLS_LANG will be something like > "ENGLISH_UNITED KINGDOM.WE8MSWIN1252" where the bit after the dot is the > character set - does that match the value in V$NLS_PARAMETERS: > > SQL> select value from v$nls_parameters where parameter = > 'NLS_CHARACTERSET'; > > If the two are not the same, then some character set conversion will be > taking place. > > > If your client app is running on some Unix system, then check the > environment variable NLS_LANG to see what it is set to. > > > Hope this helps. > > > Cheers, > Norman. > > Norman Dunbar > Contract Senior Oracle DBA > Capgemini Database Team (EA) > Internal : 7 28 2051 > External : 0113 231 2051 > > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify the > sender immediately, delete it and do not copy it to anyone else. We have > checked this email and its attachments for viruses. But you should still > check any attachment before opening it. We may have to make this message and > any reply to it public if asked to under the Freedom of Information Act, Data > Protection Act or for litigation. Email messages and attachments sent to or > from any Environment Agency address may also be accessed by someone other > than the sender or recipient, for business purposes. If we have sent you > information and you wish to use it please read our terms and conditions which > you can get by calling us on 08708 506 506. Find out more about the > Environment Agency at www.environment-agency.gov.uk > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify the > sender immediately, delete it and do not copy it to anyone else. > > We have checked this email and its attachments for viruses. But you should > still check any attachment before opening it. > We may have to make this message and any reply to it public if asked to under > the Freedom of Information Act, Data Protection Act or for litigation. Email > messages and attachments sent to or from any Environment Agency address may > also be accessed by someone other than the sender or recipient, for business > purposes. > > If we have sent you information and you wish to use it please read our terms > and conditions which you can get by calling us on 08708 506 506. Find out > more about the Environment Agency at www.environment-agency.gov.uk > > -- > XMLmind FO Converter Support List > [email protected] > http://www.xmlmind.com/mailman/listinfo/xfc-support > > -- XMLmind FO Converter Support List [email protected] http://www.xmlmind.com/mailman/listinfo/xfc-support
