Accent

[bensmail]

Hi all,

I have some Display problem. I can see the Frensh caracter as: é or ç,.....

Oracle server:
NLS_LANG:French_FRANCE.WEISO8859P1

and
Oracle Client:
NLS_LANG:French_FRANCE.WEISO8859P1

How can i correct them.


Bensmail

[sai_sathish]

You may have to find the correct french character and its ascii value and update the wrong characters with the correct one using the ascii value.

[bensmail]

can u give me a exemple. I don't understand the Idea.

Thank's

[sai_sathish]

Suppose, if you find a character é which is not a french, then,
you have to find the correct french character and its ascii value.
After finding the ascii value of the actual french character, you can
update the é using replace command with the correct french character.

1. Find the ascii value of é first.


For ex if I have the é character in the JOB column you can find the ascii value by running the below select statement:

SELECT DUMP(JOB) FROM EMP WHERE EMPNO = 7902;

DUMP(JOB)
--------------------------------------------------------------
Typ=1 Len=7: 65,78,65,76,89,83,84

This will display the ascii value of each character in the job column. You can select the ascii value for é say 83.

2. Now, get the ascii value of the correct one (say 110) which replace the é.

3. Then you can run a update statement like this.

update emp set job=replace(job,chr(83),chr(110)) where empno=7902;

I hope, I am giving you the correct suggestion for your scenario.

[bensmail]

My DB is a production database and i want to see all data in Frensh caracters. The users write Data correct in Frensh in DB.
But it will be difficult to decode this caractere for futher Display.


Bensmail

[DaPi]

Hi bensmail,

I really don't understand your problem. In my db (also WE8ISO8859P1):
select swlastname from sw_person
where swlastname like '%é%';
finds "Organisation Européenne".
What will not work for displaying this?

Do you want to be able to search without the accents?
(e.g.) find the above with: like '%Europeenne%'? Or make 'français' and 'francais' equivalent?

(Si vous aimeriez exposer le problème en français . . .)

[bensmail]

Désolé mais notre Characterset est: US7ASCII et non WEISO8859P1
can we see the accents??? with this caracterset


Thank's

[DaPi]

I think you are out of luck - 7 bit ASCII does not have accents. Have a look at "Oracle8i National Language Support Guide" Chapter 3. But it looks like "alter database character set" would get you to (e.g.) WE8ISO8859P1. (Test & BACKUP !! !!).

[pipo]

You do not have a chance of seing an accent if using a 7 bit character set, nevertheless you're quite lucky since as DaPi said, changing from US7ASCII to WE8ISO8859P1 won't be a problem since US7 is a subset of WE8.

Your real problem is that you won't be able to recover accents in data which is already stored...