db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-69) RFE: HEX function
Date Wed, 23 May 2012 19:15:41 GMT

    [ https://issues.apache.org/jira/browse/DERBY-69?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13281812#comment-13281812

Dag H. Wanvik commented on DERBY-69:

I think we would rather want to support the standard <Unicode character string literal>,
which would allow hex escapes, e.g.

U&"b\00E5t" giving "båt"


U&"b|00E5t" UESCAPE '|' where we choose a non-default quote character.

> 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
> 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message