FAQ
Hi Oracle gurus,

Firstly, big thanks to Kyle, Mark & Jared for taking care of the post
privilege issue.

Jumping straight at the performance question, currently on one of the
applications, I'm using WE8MSWIN1252 characterset and using 916
NVARCHAR2 columns of the total 2880 columns in the schema(282 tables).
I'm recommending to create the DB with UTF8 characerset and switch all
916 NVARCHAR2 to VARCAR2 within the schema and expand the column
length to accommidate the multibyte characters, to take care of
truncation issues with CS change.

Question: What would be the performance impact(good/bad)?
Using utf8 in the past, performance was slightly low when doing string
comparison.

Could you please share your experience or any pointers.

Thank you
Raju

Search Discussions

  • David Fitzjarrell at Sep 28, 2011 at 11:52 pm
    We're running a 3-node RAC with AL32UTF8 as the characterset and we experience no performance issues related to the character set definition.

    David Fitzjarrell


    From: Raju Angani <angani@gmail.com>
    To: oracle-l@freelists.org
    Sent: Wednesday, September 28, 2011 4:41 PM
    Subject: UTF8 Vs. WE1252 performance

    Hi Oracle gurus,

    Firstly, big thanks to Kyle, Mark & Jared for taking care of the post
    privilege issue.

    Jumping straight at the performance question, currently on one of the
    applications, I'm using WE8MSWIN1252 characterset and using 916
    NVARCHAR2 columns of the total 2880 columns in the schema(282 tables).
    I'm recommending to create the DB with UTF8 characerset and switch all
    916 NVARCHAR2 to VARCAR2 within the schema and expand the column
    length to accommidate the multibyte characters, to take care of
    truncation issues with CS change.

    Question: What would be the performance impact(good/bad)?
    Using utf8 in the past, performance was slightly low when doing string
    comparison.

    Could you please share your experience or any pointers.

    Thank you
    Raju

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 28, '11 at 11:42p
activeSep 28, '11 at 11:52p
posts2
users2
websiteoracle.com

2 users in discussion

Raju Angani: 1 post David Fitzjarrell: 1 post

People

Translate

site design / logo © 2022 Grokbase