Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n)
CHARACTER SET OCTETS
-------------------------------------------------------------------------------------------------
Key: CORE-5064
URL: http://tracker.firebirdsql.org/browse/CORE-5064
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Mark Rotteveel
The CHAR(n) CHARACTER SET OCTETS and VARCHAR(n) CHARACTER SET OCTETS types are
basically the SQL standard type BINARY and VARBINARY (or BINARY VARYING).
Please add the following aliases for these types:
* BINARY(n) for CHAR(n) CHARACTER SET OCTETS
* VARBINARY(n) for VARCHAR(n) CHARACTER SET OCTETS
* BINARY VARYING(n) for VARCHAR(n) CHARACTER SET OCTETS
Using either the alias or the 'old' full definition should become an explicit
subtype of CHAR and VARCHAR, instead of implicit based on the character set id
as it is now. This can be achieved by setting the subtype in RDB$FIELD_SUB_TYPE
(in RDB$FIELDS and RDB$FUNCTION_ARGUMENTS) to 1 (CS_BINARY). This has the added
benefit that tools can use this information to determine the data type
consistently based on type and subtype; this would be compatible with current
usage of the sqlsubtype in XSQLVAR to communicate the character set id.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
