11

In Oracle, we can use desc to return the column width of each column.

Are there any commands that we can retrieve the characterset of each column?

(for example, AL32UTF8, WE8MSWIN1252)

Thank you very much.

York Mak
  • 231
  • 1
  • 3
  • 8

1 Answers1

23

A column doesn't have a character set in Oracle. A database has a character set and a national character set. All char, varchar2, and clob columns use the database character set. All nchar, nvarchar2, and nclob columns use the national character set.

You can see both character sets by running

SELECT *
  FROM v$nls_parameters
 WHERE parameter LIKE '%CHARACTERSET'
Justin Cave
  • 227,342
  • 24
  • 367
  • 384