Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.


Ispirer SQLWays Database Migration Software

char, varchar and long varchar

Character data types are used to store character data.

char[(n)]
character[(n)]

Fixed-length character data with length of n characters. n must be a value from 1 through 32767. For strings up to 254 bytes, the storage size is n +1 bytes. There are more additional bytes used for longer strings.

You can store multi-byte characters as the char data type.

varchar[(n)]
character varying[(n)]

Variable-length character data with length of n characters. n must be a value from 1 through 32767. For strings up to 254 bytes, the storage size is n +1 bytes. There are more additional bytes used for longer strings.

You can store multi-byte characters as the varchar data type.

long varchar

Variable-length character data. The size is limited by the maximum size of the database file (currently 2 Gb). There are some subsidiary bytes used for storage in addition to the length of the string.

Remarks

When n is not specified in a data definition, the default length is 1. Data type lengths of less than one are not allowed. After the 255th byte characters are stored separately form the row containing the long string value.


Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.