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个字节)；在整理文本数据时支持使用代码集顺序。
The length allowed for a LONG VARCHAR is greater than 32672 and this could result in truncation of data.
LONG VARCHAR所允许的长度大于32672，这将导致数据的截断。
Traditionally, relational DBMSs stored XML data as a single column-row entity (such as CLOB, BLOB, or VARCHAR) or decomposed ("shred") the XML data into multiple columns.
通常，关系型DBMS 将XML数据作为单个的列-行实体（例如CLOB、BLOB或VARCHAR）进行存储，或将 XML 数据分解（“撕碎”）为多个列。
CHAR and VARCHAR of different lengths are compatible data types.
不同长度的CHAR和VARCHAR是兼容的数据类型。
Rename the second attribute to DESCRIPTION and change its data type to VARCHAR (1024).
将第二个属性重新命名为DESCRIPTION，并将它的数据类型改为VARCHAR (1024)。
For example, the following statement produces a result set similar to the previous one, except that "Message" data is contained in an XML column rather than an SQL VARCHAR column.
例如，以下语句产生类似于上述结果的结果集，不同的是“Message ”数据被包含在一个xml列中，而不是包含在一个SQL varchar列中。
The maximum length for a VARCHAR column may seem sufficiently large, but Derby provides larger character data types, which will be discussed in a future article.
VARCHAR列的最大长度看起来可能足够大了，但是Derby 还提供了更大的字符数据类型，这个类型将在未来的文章中讨论。
Derby provides two simple techniques for storing character data: the char type and the VARCHAR type, which are detailed in Table 3.
Derby提供了保存字符数据的两个简单技术：char类型和varchar类型，详情如表3所示。
The data type of the register is VARCHAR(255).
寄存器的数据类型为 VARCHAR(255)。
VARCHAR (30) is the data type of the variable.
VARCHAR(30)表示变量的数据类型。
MTK maps the ENUM data type to VARCHAR(255) with check constraint.
MTK 将ENUM数据类型映射到带检查约束的VARCHAR(255)。
The index key limit might be reduced when you are using VARCHAR or VARGRAPHIC data type.
当使用VARCHAR或VARGRAPHIC数据类型时，索引键限制可能减少。
For example, DB2 UDB federated servers do not support mappings for the data type of LONG VARCHAR.
例如，DB 2udb联邦服务器不支持数据类型LONG VARCHAR的映射。
The ROWID data type is mapped to VARCHAR(16) FOR BIT and the RID_BIT() function is added to support the ROWID operations.
ROWID数据类型被映射到VARCHAR(16)FORBIT，并增加了 RID_BIT()函数，以支持 ROWID 操作。
XMLCAST: a new SQL function that converts an XML node's value into a relational data type, such as VARCHAR, INTEGER, DATE, and so on.
XMLCAST：这个新的SQL函数将xml节点的值转换为关系数据类型，比如VARCHAR、INTEGER、DATE等等。
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。
Creation of a multiple partition table that contains only long data types (long VARCHAR, long VARGRAPHIC, BLOB, CLOB, or DBCLOB) is not supported.
只包含long数据类型(longVARCHAR、longVARGRAPHIC、BLOB、CLOB或DBCLOB)的多分区的表的创建是不受支持的。
For example, you can now change a column defined with a data type of INTEGER to have a data type of VARCHAR, or you can change a data type of TIMESTAMP to DATE.
例如，现在可以修改一个数据类型为INTEGER的列，从而拥有一个VARCHAR数据类型，或者将数据类型从TIMESTAMP修改为DATE。
Datatypes like VARCHAR and CLOB allow you to store plain ASCII text, and BLOBs provide for storage of complex (proprietary) types of data, like.pdf,.doc,.ppt,.rtf,.xml and so on.
诸如VARCHAR和clob之类的数据类型允许您存储无格式ascii文本，而BLOB数据类型允许存储复杂(专有)类型的数据，如. pdf、。doc、。ppt、。rtf、。xml等。
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)创建别名。
The reason is simply that inlined data is treated exactly like VARCHAR FOR BIT data.
原因是，内联的数据当作VARCHAR FORBIT DATA对待。
Data types (integer or varchar, for example).
数据类型(例如，integer或varchar)。
DB2 array data types yielded significantly higher performance compared to varchar representations of arrays.
与阵列的varchar表示相比，DB 2阵列数据类型具有显著的高性能。
On the data Privacy TAB, Tom indicates the following for the customer email address, identifying it as a VARCHAR (128) data type, as shown in Figure 11.
在DataPrivacy选项卡上，Tom指出关于客户电子邮件地址的信息，并将其标识为VARCHAR(128)数据类型，如图11所示。
Using VARCHAR for bit data allows DB2 to perform better when working with the records in this table.
使用VARCHAR forbitdata可以使DB2在处理此表中的记录时执行得更好。
If the internal representation of the spatial value requires less bytes than specified in the inline length setting, then it will be stored inline as VARCHAR FOR BIT DATA.
如果空间值的内部表示需要的字节数少于inlinelength设置中指定的值，那么它将以内联(inline)的方式存储为VARCHAR FORBIT DATA。
Reserved extended table field: Pre-define a fixed number of additional data columns in each table with a generic column type (e.g. varchar).
保留的扩展表字段：在每个表中预先定义固定数量的额外数据列，这些列采用通用列类型（比如 varchar）。
CLPPlus supports variables of various data types, including integer, decimal, varchar, varchar2, number, Boolean, row, array of rows, cursor, etc.
CLPPlus支持各种数据类型的变量，包括integer、decimal、varchar、varchar2、number、Boolean、row、arrayofrows、cursor等。
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.
如果值被串行化为不是FOR BIT DATA 的CHAR、VARCHAR或CLOB类型，那么会有一个到SQL世界的代码页转换。
The deciding factor to determine whether a geometry will be stored as VARCHAR FOR BIT DATA or as BLOB is the so-called inline length that is applicable to a spatial column in any table.
确定几何图形是存储为VARCHAR FORBITDATA还是BLOB的决定因素就是所谓的inlinelength，这个参数适用于任何表中的空间列。
应用推荐