Accent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Accent

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    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

  2. #2
    Join Date
    Nov 2002
    Posts
    39
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    can u give me a exemple. I don't understand the Idea.

    Thank's

  4. #4
    Join Date
    Nov 2002
    Posts
    39
    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

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    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

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  7. #7
    Join Date
    Mar 2002
    Posts
    301
    Désolé mais notre Characterset est: US7ASCII et non WEISO8859P1
    can we see the accents??? with this caracterset


    Thank's

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  9. #9
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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
  •  


Click Here to Expand Forum to Full Width