Class TTypeName

Object
gudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.nodes.TTypeName
All Implemented Interfaces:
Visitable, Cloneable, Iterator<TSourceToken>

public class TTypeName extends TParseTreeNode implements Cloneable
This class represents SQL Datatype. call method toString will return string representation of datatype including type name,length,precision,scale and attributes

datetype attribute
In datatype like this: MEDIUMTEXT [CHARACTER SET cs_name] [COLLATE collation_name], CHARACTER SET and COLLATE were treated as attribute of the MEDIUMTEXT datatype,those attributes can be fetched from getDatatypeAttributeList(). For more detailed information about attributes in datatype, please check TDatatypeAttribute.

method getDatatypeAttributeList() can be used to get datatype attribute such as FORMAT 'yyyymmdd' of DATE in this fuction: CAST('20120802' AS DATE FORMAT 'yyyymmdd').

BINARY

BOOLEAN

CHARACTER STRING

DATALINK

INTERVAL

COLLECTION

  • ARRAY
  • MULTISET

NUMERIC

TEMPORAL

XML

HIVE array

OTHERS

  • BFILE(Oracle)
  • EDataType.bfile_t
  • BIT(MySQL,PostgreSQL,SQL Server)
  • BITVARYING/VARBIT(PostgreSQL)
  • BOX(PostgreSQL)
  • CIDR(PostgreSQL)
  • CIRCLE(PostgreSQL)
  • CURSOR(SQL Server)
  • ENUM(MySQL, PostgreSQL)
  • GEOGRAPHY(SQL Server)
  • EDataType.geography_t
  • GEOMETRY(SQL Server)
  • EDataType.geometry_t
  • HIERARCHYID(SQL Server)
  • INET(PostgreSQL)
  • LINE(PostgreSQL)
  • LONG(Oracle)
  • EDataType.long_t
  • LONG VARCHAR
  • LONG VARGRAPHIC
  • LONGTEXT(MySQL)
  • LSEG(PostgreSQL)
  • MACADDR(PostgreSQL)
  • MEDIUMBLOB(MySQL)
  • MEDIUMTEXT(MySQL)
  • MONEY(PostgreSQL,SQL Server)
  • OID(PostgreSQL)
  • PATH(PostgreSQL)
  • POINT(PostgreSQL)
  • POLYGON(PostgreSQL)
  • RAW(Oracle)
  • EDataType.raw_t
  • ROWID(Oracle)
  • ROWVERSION(SQL Server)
  • SERIAL, SERIAL4(MySQL,PostgreSQL)
  • SERIAL8, BIGSERIAL(PostgreSQL)
  • SET(MySQL)
  • SMALLMONEY(SQL Server)
  • SQL_VARIANT(SQL Server)
  • TABLE(SQL Server)
  • UNIQUEIDENTIFIER(SQL Server)
  • UROWID(Oracle)

datatypes optional attributes:

  • NSIGNED (MySQL)
  • ZEROFILL (MySQL)
  • CHARACTER SET cs_name (MySQL)
  • COLLATE collation_name (MySQL)
See Also: