db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DERBY-69) RFE: HEX function
Date Tue, 12 Mar 2013 11:45:13 GMT

     [ https://issues.apache.org/jira/browse/DERBY-69?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen closed DERBY-69.
-----------------------------------

    Resolution: Duplicate

DERBY-1360 tracks the request for Unicode character literals. As Dag points out, that would
be the preferred way to implement the functionality requested here, so I'm closing this issue
for now. Further discussion could continue over at DERBY-1360.
                
> RFE: HEX function
> -----------------
>
>                 Key: DERBY-69
>                 URL: https://issues.apache.org/jira/browse/DERBY-69
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Christian d'Heureuse
>
> It would be good to have a built-in HEX function, or another method to create character
values with arbitrary ASCII values (e.g. TAB, CR/LF, etc.).
> If "CHAR FOR BIT DATA" values could be converted to CHAR or VARCHAR, the x'...' syntax
could be used to create binary character constants. But I found no way to convert "CHAR FOR
BIT DATA" to CHAR.
> I didn't find an explicit description of the X'...' syntax in the reference manual. The
only 2 occurences are in the SQL examples of the LENGTH function ("VALUES LENGTH(X'FF')")
and of the "CHAR FOR BIT DATA" data type ("INSERT INTO t VALUES (X'DE');"). Is the x'...'
syntax an unwanted remains from an old Cloudscape version, or will it still be supported (and
properly documeted) in future Derby versions?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message