4D v14
literal
- 4D SQL Reference
-
- Syntax rules
-
- Syntax rules
- 4d_function_call
- 4d_language_reference
- all_or_any_predicate
- arithmetic_expression
- between_predicate
- case_expression
- column_definition
- column_reference
- command_parameter
- comparison_predicate
- exists_predicate
- foreign_key_definition
- function_call
- in_predicate
- is_null_predicate
- like_predicate
- literal
- predicate
- primary_key_definition
- search_condition
- select_item
- sort_list
- sql_data_type_name
- sql_name
- sql_string
- subquery
- table_constraint
- table_reference
literal
|
|
||
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.
Product: 4D
Theme: Syntax rules
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 )
