• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 960
  • Last Modified:

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.

0
xinglie
Asked:
xinglie
  • 2
1 Solution
 
vanmeerendonkCommented:
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
0
 
xinglieAuthor Commented:
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?
0
 
vanmeerendonkCommented:
Yep, i got the accent.
As i understand it, you're using US7ASCII.
Well, forget the accent. 7-bit Americans don't do
accents.

When you change your characterset to a normal one (WE8 etc.) you can store aout with an accent, but the other database has a subset-charecterset and will translate it to aout (without an accent).

0
 
MoondancerCommented:
Awaiting your response and finalization.
Moondancer
Community Support Moderator @ Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now