asked on

French accent missing

Hi, I need help.
When I use following sql:
select to_char(sysdate,'dd month yyyy','NLS_DATE_LANGUAGE=FRENCH') from dual;

I got the result likes '09 aout 2001'.

aout in French is August. But the French accent is missing. It should be aout.

Any suggestion is appreciated.

vanmeerendonk

there are a few items you have to look at:
select * from v$nls_parameters
especially the NLS_CHARACTERSET must be able to handle the accent
in my case it's WE8ISO8859P1
And then you have to look at the client-machine.
Given that you are using NT:
Look at settings>control panel>Regional Settings and check all the tabs
In my case: english

When I execute the statement I get
09 aout 2001

Check you client-machine

xinglie

ASKER

Thanks.
But this database needs to exchange data with other database which is using characterset US7ASCII. So we don't want to set the characterset to WE8ISO8859SP1. Actually it can store French words now.
Do you have any idea about it? or We have to change the characterset?

By the way, on my browser, the result you get is also without French accent. I think the database of Expert exchange has same problem. Would you please tell me whether you got a word 'aout' with French accent?

ASKER CERTIFIED SOLUTION

vanmeerendonk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Moondancer

Awaiting your response and finalization.
Moondancer
Community Support Moderator @ Experts Exchange