|Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » Types » String Types|
|A string value with a fixed number of characters. If the length of the string value is not specified, then a length of 1 is used. The maximum length is 1024 characters. When assigning a value to a CHAR type value that is smaller in length than the specified length, the value being assigned will be padded with spaces to the specified length. For example, if you have a column defined as:|
If you were to assign the value 'Test' to the column, then the MyColumn column would contain the value 'Test'+<16 Spaces> after the assignment.
|A string value with a variable number of characters. The length of the string value must always be specified. The maximum length is 1024 characters. Contrary to the CHARACTER type, this type does not pad the string value with spaces.|
|GUID||A string value that has an exact length of 38 characters. A GUID value is treated the same as a VARCHAR value.|
|CHARACTER LARGE OBJECT|
|A large, variable-length string value with a maximum size of 2GB.|
-- This example specifies a VARCHAR literal SELECT * FROM Customer WHERE Name = 'Acme Boot Makers' -- This example specifies a VARCHAR literal with -- embedded quotes SELECT * FROM Customer WHERE Name = 'Bill''s Shoes' -- This example specifies two CHAR literals (a carriage -- return and line feed) using pound sign (#) notation SELECT * FROM Documentation WHERE Notes LIKE '%'+#13+#10+'%'
|NATIONAL Types||ElevateDB does not support the NATIONAL versions of the CHARACTER, CHARACTER VARYING (VARCHAR), or CHARACTER LARGE OBJECT (CLOB) types. See the Internationalization topic for more information.|
|CLOB Type||ElevateDB does not support the specification of a default size in KB, MB, or GB for large object types.|
|GUID Type||ElevateDB adds the GUID type as an extended type.|