4D v14

literal

Home

 
4D v14
literal

literal  


 

 

 Command literaint_number | fractional_number | sql_string | hexadecimal_number

A literal is a data type consisting of either an int_number (integer), a fractional_number (fraction), an sql_string  or a hexadecimal_number.

Hexadecimal notation (introduced in 4D 12.1) can express any type of data represented as bytes. A byte is always defined by two hexadecimal values. To indicate the use of this notation in an SQL command, you must simply use the standard SQL syntax for hexadecimal values:

X'<hexadecimal value>'

For example, for the decimal value 15, you can write X'0f'. You can set a blank value (zero byte) by writing X''.

Note: The SQL EXPORT DATABASE and SQL EXPORT SELECTION commands export binary data in hexadecimal format when these data are embedded in the main export file.

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
SEE ALSO 

arithmetic_expression

 
ARTICLE USAGE

4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)

Inherited from : literal ( 4D v11 SQL Release 4 )