UTF8 Vs. WE1252 performance
Date: Wed, 28 Sep 2011 16:41:18 -0700
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.