如何查看Oracle表列字符集? [英] How to view Oracle table column character set?

问题描述

在Oracle中，我们可以使用desc返回每列的列宽.

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?

(例如，AL32UTF8，WE8MSWIN1252)

(for example, AL32UTF8, WE8MSWIN1252)

非常感谢您.

推荐答案

列在Oracle中没有字符集.数据库具有字符集和国家字符集.所有char，varchar2和clob列均使用数据库字符集.所有nchar，nvarchar2和nclob列均使用国家字符集.

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'

这篇关于如何查看Oracle表列字符集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！