Hello Hussein and Norman,
Thank you so much for your informations. I have checked my database by
running the query, and i got the following result.
WE8MSWIN1252.
one more information, I am using servlet to open my rtf document from the
web application. My application is running in weblogic server. Actually i
did a small standalone program to test this. My test program connect and
query the database and getting the data, generate a xml and then using
transformer xml and xslt creates the xsl-fo then using xmlmind i am
converting xsl-fo to RTF doc. I don't have any problem creating that. It
creates the RTF doc find with the special characters. Only problem is as
soon as i deploy it in the weblogic that's where the problem is.
My servlet code is as follows:
Here also i have given the encoding type as UTF-8.
response.setContentType("application/rtf;charset=UTF-8");
response.setCharacterEncoding("UTF-8");
Probably i may have to see how to set up the encoding type in servlet
container.
Thank you both again for all your help.
Regards,
Kavitha.
On Tue, Jul 20, 2010 at 1:19 AM, Dunbar, Norman (Capgemini) <
[email protected]> 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
