Database Tuning (MOSC)

MOSC Banner

VARCHAR2 or NVARCHAR2

edited Oct 21, 2010 4:25PM in Database Tuning (MOSC) 8 commentsAnswered ✓
 Hi All,

The question comes from one review session of physical data model  in our database team. We usually use NVARACHAR2 to hold the strings which may constain special symbols such as copyright and it really works for most of cases.

In a short, we usually use VARCHAR2 for all string columns. But if business team says it may contain special symbols, we change the field to NVARCHAR2.

My question is why we can't use NVARCHAR2 for every column as we use VARCHAR2?

I don't know this design is correct or not. But I haven't really seen this kind of design that use NVARCHAR2 everywhere before.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center