Solved

French accent missing

Posted on 2001-08-09
4
893 Views
Last Modified: 2012-05-04
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
Comment
Question by:xinglie
  • 2
4 Comments
 
LVL 2

Expert Comment

by:vanmeerendonk
ID: 6368179
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
 

Author Comment

by:xinglie
ID: 6369141
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
 
LVL 2

Accepted Solution

by:
vanmeerendonk earned 100 total points
ID: 6372207
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
 
LVL 1

Expert Comment

by:Moondancer
ID: 6403717
Awaiting your response and finalization.
Moondancer
Community Support Moderator @ Experts Exchange
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Consolidating oracle query results to a single line 8 65
Deleting Rows from an Oracle Database - Performance 19 53
Fill Date time Field 12 23
oracle collections 2 20
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question