User Documentation
Ispirer Capabilities - Sybase Migration
Pricing
Sybase ASE Data Types - VARCHAR
Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x
Sybase ASE - VARCHAR | |
---|---|
Syntax | VARCHAR[(n)] |
Data | Variable-length character data, single-byte and multibyte character sets |
Parameters | n is the maximum number of bytes, optional |
Range | 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K) |
Default | n is 1 |
Padding | Not right-padded with spaces to n |
Trailing Spaces | Removed when the value is stored |
Empty String | “” is stored as a single space “ ” |
Error Handling | Exceeding data truncated without warning if set string_rtruncation off specified (default), otherwise an error is raised |
Storage Size | actual entry length |
Synonyms | CHAR VARYING, CHARACTER VARYING |
Standards | ANSI SQL |
Sybase ASE VARCHAR - Equivalents in Other Databases
Database | Data Type and Conversion |
---|---|
Oracle | VARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize |
SQL Server | VARCHAR(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified |
MySQL | VARCHAR(n), 1 ⇐ n ⇐ 65535/charsize |
PostgreSQL | VARCHAR(n), 1 ⇐ n ⇐ 1G |
Informix | VARCHAR(n,r), 1 ⇐ n ⇐ 255, LVARCHAR(n), 1 ⇐ n ⇐ 32739 |
HP Neoview | VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns) |
Ingres | VARCHAR(n), 1 ⇐ n ⇐ 32000 |
Related Data Types in Sybase ASE
Data Types | |||
---|---|---|---|
Fixed-length character data | CHAR(n) | NCHAR(n) | UNICHAR(n) |
Variable-length character data | NVARCHAR(n) | UNIVARCHAR(n) | |
Character large objects | TEXT | UNITEXT |
All Data Types