Text - Data Type

Data System Architecture

About

Type in Text

Data Type

Primitive

  • Fixed text, size N means that the column must be able to hold any string of characters of a fixed length of N. If the string it holds is shorter than N characters, then trailing spaces must be stored in the database or the database must automatically pad with spaces upon retrieval such that a CHAR_LENGTH() function will return N.
  • Variable text, size N means that the column must be able to hold any string of characters of a variable length with a maximum length of N.

Complex





Discover More
Tpc H Schema
TPC - TPC-H Decision Support Benchmark Sample Schema

TPC-H is an ad-hoc, decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The TPC-H benchmark...



Share this page:
Follow us:
Task Runner