varchar

varchar

 英

  • 网络变长字符串;可变长度;数据类型

例句

More Detail: A page would be displayed where a user can enter their email address and a reference (mandatory - string - varchar(100)).

更多详情一个页面显示其中一个用户可以输入他们电子邮件地址引用强制--varchar(100))。

At the beginning of each char or varchar field, bcp adds the prefix length.

每个char字段varchar字段开头bcp添加前缀长度

The index key of a clustered index cannot contain varchar columns that have existing data in the ROW_OVERFLOW_DATA allocation unit.

聚集索引索引不能包含ROW_OVERFLOW_DATA分配单元具有现有数据varchar

In a VARCHAR column, the XML Extender only stores documents up to 3KB in size -- a limit which is hard to guarantee in many applications.

VARCHARXML扩展存储最大3KB文档-许多应用程序限制很难得到保证

If you know the UTF-8 encoding of a character, you can also use this method to enter Unicode characters in a CHAR or VARCHAR column.

如果知道字符UTF-8编码可以这种方法CHARVARCHAR输入Unicode字符

VARCHAR Stores single-byte or multibyte text strings of varying length (up to 255 bytes); supports code-set order collation of text data.

VARCHAR存储可变长度字节字节文本字符串最高255字节);整理文本数据支持使用代码顺序

For instance, a String attribute of an entity could be implemented as a CHAR, VARCHAR, or TEXT type of column.

例如可以实体String类型属性实现CHARVARCHARTEXT类型

First, the CHAR type has a maximum length of 254 characters, whereas the VARCHAR type can hold up to 32, 672 characters.

首先CHAR类型最大长度254字符VARCHAR类型最多可以容纳32,672字符

Trailing blanks in character values inserted into a varchar column are trimmed.

剪裁插入varchar字符尾随空格

With a VARCHAR, the number of characters can vary, and no extra padding is performed.

使用VARCHAR字符数量可变执行额外填充

By default, an empty string is interpreted as an empty string in INSERT or assignment statements on data of the varchar data type.

默认情况对于varchar数据类型数据INSERT赋值语句字符串解释字符串

But, you could decide to index book prices as VARCHAR, as shown in Table 3.

但是可以书籍价格作为VARCHAR进行索引3

The length of a VARCHAR(n) index is a hard constraint.

VARCHARn索引长度一个强制约束

In concatenating data of the varchar, char, or text data types, the empty string is interpreted as an empty string.

串联varcharchartext数据类型数据字符串解释字符串

Server_name This varchar(128) parameter specifies the name of the remote server that is being used to connect to the remote database.

server_namevarchar(128)参数指定用于连接远程数据库远程服务器名称

We also specify that the function will return a VARCHAR(42), which is large enough to hold the concatenated address attributes.

指定函数返回一个足以保留连接地址属性VARCHAR(42)。

Separate structures are used to hold the allocated, stored, and untruncated lengths of LONG BINARY and LONG VARCHAR data types.

使用单独结构保存LONGBINARYLONGVARCHAR数据类型分配长度存储长度截断长度

Since logically the XML column appears the same as a VARCHAR, CLOB, or BLOB column, the INSERT statements are also similar.

因为从逻辑上XMLVARCHARCLOBBLOB相似所以INSERT语句也是相似

Additional information is logged for long varchar and LOB fields in a database enabled for roll-forward recovery.

对于为了恢复数据库启用longvarcharLOB字段这样附加信息记录日志

If the values are of type VARCHAR or a numerical data type, which can be converted to type VARCHAR, the resulting type is VARCHAR.

如果VARCHAR类型数值数据类型可以转换VARCHAR类型),结果类型VARCHAR

Any char and varchar values that are transferred between sql_variant columns may have code page conversion issues.

sql_variant之间传输任何charvarchar可能存在代码转换问题

The groups will be identified by VARCHAR values but can as well be defined as integers.

通过VARCHAR识别分组可以分组定义整数

Sybase: If the source table has a column data type of LONG VARCHAR, the nickname is created with a data type of VARCHAR(32672).

Sybase如果具有数据类型LONGVARCHAR就要数据类型VARCHAR(32672)创建别名

We strongly recommend that you use VARCHAR in the consolidated database rather than CHAR.

我们强烈建议统一数据库使用VARCHAR不是CHAR

Text indexes can be created on a range of data types from small VARCHARs to large BLOBs that contain text objects.

文本索引可以广泛范围数据类型创建包括小型VARCHAR大型BLOB包含文本对象数据类型

Native (database) data types, except in char, varchar, and text columns, in which data is stored as Unicode.

数据库数据类型除了charvarchartext以外数据存储Unicode

pb produced when changes varchar field length, we also need amendments to a dw, more trouble.

pb制作修改varchar字段长度我们需要一个个修改dw比较麻烦

There is a code page conversion to the SQL world if the value is serialized into a CHAR, VARCHAR, or CLOB type that is not FOR BIT DATA.

如果串行化为不是FORBITDATACHARVARCHARCLOB类型那么一个SQL世界代码转换

Default parameter values can be specified for CLR functions except for varchar(max) and varbinary(max) data types.

可以varcharmaxvarbinarymax数据类型之外CLR函数指定默认参数

Is a string expression of type char, varchar, or varchar(max) defined on a tertiary SQL collation.

针对第三SQL排序规则定义类型charvarcharvarcharmax字符串表达式

THE CAST, CONVERT, and COLLATE functions are collation sensitive for char, varchar, and text data types.

对于charvarchartext数据类型CASTCONVERTCOLLATE函数区分排序规则

The index key limit might be reduced when you are using VARCHAR or VARGRAPHIC data type.

使用VARCHARVARGRAPHIC数据类型索引限制可能减少

You can only define an index on a column defined with VARCHAR(1021).

只能VARCHAR(1021)定义定义索引

You can choose to make the underlying storage a CLOB column, a VARCHAR column, or files within the file system.

选择CLOBVARCHAR文件系统文件用作基础存储

For example, a field containing a variable-length string with a maximum length of 20 characters would be represented as "varchar(20)" .

例如一个包含可变长度字符串最大长度20字符字段表示varchar(20)”。

In this case, the customer's status is captured in an SQL VARCHAR column.

这个例子客户状态SQLVARCHAR捕捉

Connection group names support any valid value of type VARCHAR in the underlying repository database.

连接名称可以底层存储库数据库允许任何VARCHAR类型

Trailing blanks in character values inserted into varchar columns are not trimmed.

剪裁插入varchar字符尾随空格

A way to work around this is to cast the return of the query to a VARCHAR using a cast function.

解决问题一种方法使用转型函数查询返回数据转型VARCHAR

varchar columns will become text inputs, booleans map onto HTML checkboxes, etc.

varchar变成文本输入boolean变量映射HTML复选框等等