-
Accent
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
-
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.
Sathish
-
can u give me a exemple. I don't understand the Idea.
Thank's
-
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.
Sathish
-
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
-
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 . . .)
Last edited by DaPi; 02-13-2003 at 09:43 AM.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Désolé mais notre Characterset est: US7ASCII et non WEISO8859P1
can we see the accents??? with this caracterset
Thank's
-
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 !! !!).
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|