SQL 2008 R2-您为定义的字段长度的字母数字数据选择哪种数据类型. [英] SQL 2008 R2 - What datatype do you pick for Alphanumeric data with a defined field length.

问题描述

SQL 2008 R2-您为定义了字段长度的字母数字数据选择哪种数据类型.

SQL 2008 R2 - What datatype do you pick for Alphanumeric data with a defined field length.

推荐答案

(n)varchar最适合字母数字字段.简单的(n)char将用空格填充文本.

(n)varchar is most suitable for alphanumeric fields. Simple (n)char will pad text with spaces.

如果按字母数字数据表示，除简单的标准西方字符外，不需要其他任何东西，而无需强调，通常只需要字母和数字，那么我会选择char([your length]).

如果不是，那么nchar([your length])可能是合适的.

If, by alphanumeric data, you mean that you do not need anything else than simple standard western characters, without accentuation, typically only letters and numbers, then I would go for a char([your length]).

If not, then a nchar([your length]) could be appropriate.

我不知道如何在回答问题后关闭问题?

I don''t know how to close a question once it''s been answered?

这篇关于SQL 2008 R2-您为定义的字段长度的字母数字数据选择哪种数据类型.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！