oracle 如何查看Oracle表列字符集？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/34890980/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to view Oracle table column character set?
提问by York Mak
In Oracle, we can use desc to return the column width of each column.
在 Oracle 中，我们可以使用 desc 来返回每列的列宽。
Are there any commands that we can retrieve the characterset of each column?
是否有任何命令可以检索每列的字符集？
(for example, AL32UTF8, WE8MSWIN1252)
（例如，AL32UTF8、WE8MSWIN1252）
Thank you very much.
非常感谢。
回答by Justin Cave
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 clobcolumns use the database character set. All nchar, nvarchar2, and nclobcolumns use the national character set.
列在 Oracle 中没有字符集。一个数据库有一个字符集和一个国家字符集。所有char、varchar2和clob列都使用数据库字符集。所有nchar、nvarchar2和nclob列都使用国家字符集。
You can see both character sets by running
您可以通过运行查看两个字符集
SELECT *
FROM v$nls_parameters
WHERE parameter LIKE '%CHARACTERSET'
