VARCHAR(size)

The VARCHAR data type is a variable length data type that can contain any character you can enter from the keyboard. The minimum length of VARCHAR columns is 1 character, and the maximum length is 3992 characters. You must enter a value for the size parameter when creating a VARCHAR column.

Unlike the CHAR data type which uses spaces for padding, only the characters entered are stored in the database. When entering data in a VARCHAR column, you must enclose it in single quotes(' '). Note that double-byte characters occupy two bytes. If you are using double-byte characters you must account for this when you specify the length of the column.

e.g. 'This is a VARCHAR string.'
  'This is another VARCHAR string'

< TIMESTAMP | Contents >

Copyright 2002 SYSCOM Computer Engineering Co. All rights reserved.