CODEWITHSUNDEEP
oracle-databasecharacter-encodingcharbyte
San
San

Reputation: 21

Char Vs Byte in Oracle

I am comparing two databases which have similar schema. Both should support unicode characters.

When i describe the same table in both database, db 1 shows all the varchar fields with char, (eg varchar(20 char)) but the db2 shows without char, (varchar(20)

the second schema supports only one byte/char.

When i compare nls_database_parameters and v$nls_parameters in both database its all same.

could some one let me know what may be the change here?

Upvotes: 1

Views: 712

Answers (1)

Eggi
Eggi

Reputation: 1714

Have you checked NLS_LENGTH_SEMANTICS? You can set the default to BYTE or CHAR for CHAR/VARCHAR2 types.

If these parameters are the same on both datbases then maybe the table was created by explicitly specifying it that way.

Upvotes: 3

Related Questions