Hi Oracle gurus,
Firstly, big thanks to Kyle, Mark & Jared for taking care of the post
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
Could you please share your experience or any pointers.