FAQ
Is it possible to store and retrieve the special french characters in a
database with US7ASCII? Or, do I need to perform a characterset conversion
to WE8ISO8859P1 or UTF8 or something else? Thanks.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

Search Discussions

  • Justin Cave at Aug 30, 2004 at 8:08 pm
    No. The US7ASCII character set only encodes the first 127 ASCII characters,
    which doesn't include any of the accented Western European characters.

    Justin Cave
    Distributed Database Consulting, Inc.
    http://www.ddbcinc.com/askDDBC

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Martin Brown
    Sent: Monday, August 30, 2004 7:01 PM
    To: oracle-l_at_freelists.org
    Subject: US7ASCII / French Character

    Is it possible to store and retrieve the special french characters in a
    database with US7ASCII? Or, do I need to perform a characterset conversion
    to WE8ISO8859P1 or UTF8 or something else? Thanks.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org put
    'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Goulet, Dick at Aug 31, 2004 at 8:09 am
    Martin,

    From someone whose been there, you'll need to upgrade to =
    WE8ISO8859P1/UTF8 to store the western European characters properly. =
    US7ASCII is a subset of WE8ISO8859P1, so you won't loose anything that's =
    already there.

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: Martin Brown
    Sent: Monday, August 30, 2004 8:54 PM
    To: oracle-l_at_freelists.org
    Subject: US7ASCII / French Character

    Is it possible to store and retrieve the special french characters in a=20
    database with US7ASCII? Or, do I need to perform a characterset =
    conversion=20
    to WE8ISO8859P1 or UTF8 or something else? Thanks.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/

    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org

    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Vergara, Michael (TEM) at Aug 31, 2004 at 8:22 am
    Actually, you *can* store 8-bit characters in an US7ASCII
    database. Oracle has this...er...quirk that if you=20
    connect to the DB and your NLS_LANG value is the same as
    the database's NLS_LANG value, Oracle does not do any
    checking or correction of characters. However, when you
    change your NLS_LANG value, Oracle will regurgitate=20
    garbage for those 8-bit values.

    We discovered this when we tried to transfer data over a=20
    database link between a US7ASCII database and an
    WE8ISO8859P1 database.

    Dick, however, is right. If you're gonna store 8 bit
    characters then you should have your database enabled
    for that. It will save a lot of heartburn in the long
    run.

    Cheers,
    Mike

    -----Original Message-----
    From: Goulet, Dick
    Sent: Tuesday, August 31, 2004 6:14 AM
    To: oracle-l_at_freelists.org
    Subject: RE: US7ASCII / French Character

    Martin,

    From someone whose been there, you'll need to upgrade to =3D
    WE8ISO8859P1/UTF8 to store the western European characters properly. =
    =3D
    US7ASCII is a subset of WE8ISO8859P1, so you won't loose anything that's =
    =3D
    already there.

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: Martin Brown
    Sent: Monday, August 30, 2004 8:54 PM
    To: oracle-l_at_freelists.org
    Subject: US7ASCII / French Character

    Is it possible to store and retrieve the special french characters in =
    a=3D20
    database with US7ASCII? Or, do I need to perform a characterset =3D
    conversion=3D20
    to WE8ISO8859P1 or UTF8 or something else? Thanks.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Goulet, Dick at Aug 31, 2004 at 8:27 am
    Actuall? it's just a matte? of makin? thin?s alwa?s look ?eadable.

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: Vergara, Michael (TEM)
    Sent: Tuesday, August 31, 2004 9:26 AM
    To: oracle-l_at_freelists.org
    Subject: RE: US7ASCII / French Character

    Actually, you *can* store 8-bit characters in an US7ASCII
    database. Oracle has this...er...quirk that if you=3D20
    connect to the DB and your NLS_LANG value is the same as
    the database's NLS_LANG value, Oracle does not do any
    checking or correction of characters. However, when you
    change your NLS_LANG value, Oracle will regurgitate=3D20
    garbage for those 8-bit values.

    We discovered this when we tried to transfer data over a=3D20
    database link between a US7ASCII database and an
    WE8ISO8859P1 database.

    Dick, however, is right. If you're gonna store 8 bit
    characters then you should have your database enabled
    for that. It will save a lot of heartburn in the long
    run.

    Cheers,
    Mike

    -----Original Message-----
    From: Goulet, Dick
    Sent: Tuesday, August 31, 2004 6:14 AM
    To: oracle-l_at_freelists.org
    Subject: RE: US7ASCII / French Character

    Martin,

    From someone whose been there, you'll need to upgrade to =3D3D
    WE8ISO8859P1/UTF8 to store the western European characters properly. =
    =3D
    =3D3D
    US7ASCII is a subset of WE8ISO8859P1, so you won't loose anything that's =
    =3D
    =3D3D
    already there.

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: Martin Brown
    Sent: Monday, August 30, 2004 8:54 PM
    To: oracle-l_at_freelists.org
    Subject: US7ASCII / French Character

    Is it possible to store and retrieve the special french characters in =
    =3D
    a=3D3D20
    database with US7ASCII? Or, do I need to perform a characterset =3D3D
    conversion=3D3D20
    to WE8ISO8859P1 or UTF8 or something else? Thanks.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Michael Thomas at Aug 31, 2004 at 8:39 am
    Hi,

    Its very interesting with some data. For example,
    the micro (u looking character), if stored in
    USASCII7, gets converted to a number 6 in UTF-8
    (without conversion and across db_links). Therefore,
    1 micro gram (USASCII7) becomes 16 grams (UTF-8).
    Much more fun than ?nre?d?ble st?ff.

    Oracle's character set conversion utilities are a
    must.

    Regards,

    Mike Thomas

    "Goulet, Dick" wrote:
    Actuall? it's just a matte? of makin? thin?s alwa?s
    look ?eadable.

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    From: Vergara, Michael (TEM)

    Sent: Tuesday, August 31, 2004 9:26 AM
    To: oracle-l_at_freelists.org
    Subject: RE: US7ASCII / French Character


    Actually, you *can* store 8-bit characters in an
    US7ASCII
    database. Oracle has this...er...quirk that if
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Vergara, Michael (TEM) at Aug 31, 2004 at 10:02 am
    Ooh...that's much better than my current example. I've
    been using a name from our database - "Mu=F1oz" (the '=F1'
    character here is an 'n' with a tilde '~'). This name
    becomes "Muqoz" after a character set conversion from
    US7ASCII to WE8ISO8859P1.

    Cheers,
    Mike

    -----Original Message-----
    From: Michael Thomas
    Sent: Tuesday, August 31, 2004 6:43 AM
    To: oracle-l_at_freelists.org
    Subject: RE: US7ASCII / French Character

    Hi,

    Its very interesting with some data. For example,=20
    the micro (u looking character), if stored in
    USASCII7, gets converted to a number 6 in UTF-8
    (without conversion and across db_links). Therefore,=20
    1 micro gram (USASCII7) becomes 16 grams (UTF-8).=20
    Much more fun than ?nre?d?ble st?ff.

    Oracle's character set conversion utilities are a=20
    must.

    Regards,

    Mike Thomas

    "Goulet, Dick" wrote:
    Actuall? it's just a matte? of makin? thin?s alwa?s
    look ?eadable.
    =20
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 30, '04 at 7:49p
activeAug 31, '04 at 10:02a
posts7
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase