You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "ZheHu (Jira)" <ji...@apache.org> on 2024/12/18 01:49:00 UTC

[jira] [Updated] (CALCITE-6730) Add CONVERT function(enabled in Oracle library)

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

ZheHu updated CALCITE-6730:
---------------------------
    Description: 
Unlike standard CONVERT function implemented in Calcite:
{code:java}
convert(string bytea, src_encoding name, dest_encoding name)
{code}
Oracle's [CONVERT |https://docs.oracle.com/en/database/oracle/oracle-database/19/nlspg/sql-and-plsql-programming-in-global-environment.html#GUID-7E4AA2C5-8CD7-4836-AA69-6C8E02594FAC] works like:
{code:java}
convert(string bytea, dest_encoding name[, src_encoding name])
{code}
If the 'src_encoding' parameter is not specified, then it uses the default character set.

  was:
Unlike standard CONVERT function implemented in Calcite:
{code:java}
convert(string bytea, src_encoding name, dest_encoding name)
{code}
Oracle's [CONVERT |https://docs.oracle.com/en/database/oracle/oracle-database/19/nlspg/sql-and-plsql-programming-in-global-environment.html#GUID-7E4AA2C5-8CD7-4836-AA69-6C8E02594FAC] works like:
{code:java}
convert(string bytea, dest_encoding name[, src_encoding name])
{code}
If the 'src_encoding' parameter is not specified, then it defaults to the database character set.


> Add CONVERT function(enabled in Oracle library)
> -----------------------------------------------
>
>                 Key: CALCITE-6730
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6730
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.38.0
>            Reporter: ZheHu
>            Assignee: ZheHu
>            Priority: Major
>
> Unlike standard CONVERT function implemented in Calcite:
> {code:java}
> convert(string bytea, src_encoding name, dest_encoding name)
> {code}
> Oracle's [CONVERT |https://docs.oracle.com/en/database/oracle/oracle-database/19/nlspg/sql-and-plsql-programming-in-global-environment.html#GUID-7E4AA2C5-8CD7-4836-AA69-6C8E02594FAC] works like:
> {code:java}
> convert(string bytea, dest_encoding name[, src_encoding name])
> {code}
> If the 'src_encoding' parameter is not specified, then it uses the default character set.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)