db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian d'Heureuse (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-69) RFE: HEX function
Date Tue, 16 Nov 2004 22:59:23 GMT
RFE: HEX function

         Key: DERBY-69
         URL: http://nagoya.apache.org/jira/browse/DERBY-69
     Project: Derby
        Type: New Feature
  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

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 contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

View raw message