我怎么能看到所有的“特殊"?SQL Server 中 varchar 或 char 字段中允许的字符? [英] How can I see all the "special" characters permissible in a varchar or char field in SQL Server?

问题描述

在哪里可以看到存储在 SQL Server 中 varchar 或 char 字段中的所有不可见字符?例如\n(换行)、\r(回车)和其他不可打印"字符?

Where can I see all the non-visible characters stored on a varchar or char field in SQL Server? e.g. \n (new-line), \r (carriage return) and other "non-printable" characters?

如何打印它们(因为它们不可打印但对文本执行一些操作)?

How to print them (as they are not printable but perform some action on the text)?

推荐答案

您可能只需要查看 ASCII 和 EXTENDED ASCII 字符集.据我所知，在 char/varchar 字段中允许使用任何这些.

You probably just need to see the ASCII and EXTENDED ASCII character sets. As far as I know any of these are allowed in a char/varchar field.

如果你使用 nchar/nvarchar 那么它几乎是世界上任何 unicode 集中的任何字符.

If you use nchar/nvarchar then it's pretty much any character in any unicode set in the world.

这篇关于我怎么能看到所有的“特殊"?SQL Server 中 varchar 或 char 字段中允许的字符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！