![]() |
SQL-J Language Reference
|
Reference Manual |
VARCHARVARCHAR provides for variable-length storage of strings. NOTE: For locale-sensitive sorts and other operations, use the NVARCHAR data type. For more information, see International String Data Types. Syntax for Column Definition{ VARCHAR | CHAR VARYING | CHARACTER VARYING }(length) length is an unsigned integer literal, and it must not be greater than the constraint of the integer used to specify the length, the value java.lang.Integer.MAX_VALUE. Corresponding Compile-Time Java TypeJDBC Metadata Type (java.sql.Types)Cloudscape does not pad a VARCHAR value whose length is less than specified. Cloudscape truncates spaces from a string value when a length greater than the VARCHAR expected is provided. Characters other than spaces are not truncated, and instead cause an exception to be raised. When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored. When CHARs and VARCHARs are mixed in expressions, the shorter value is padded with spaces to the length of the longer value. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |