[jira] [Assigned] (TRAFODION-1720) add GBK support in SQL translate function

["liu ming (JIRA)" <ji...@apache.org>]

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

liu ming reassigned TRAFODION-1720:
-----------------------------------

    Assignee: liu ming

> add GBK support in SQL translate function
> -----------------------------------------
>
>                 Key: TRAFODION-1720
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1720
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-exe
>            Reporter: liu ming
>            Assignee: liu ming
>
> Trafodion support TRANSLATE function now and support character set conversion among ISO88591, SJIS, UCS2 and UTF8. It will be useful to support GBK and later BIG5.
> GBK is widely used in China. Without support, all source data need to be converted before data loading. With built-in support, it will decrease the overall data loading time.
> External interface
> Use the current SQL Function TRANSLATE, introduce new translation, keep the original syntax.
>  
> TRANSLATE(character-value-expression USING translation-name)
> Translation-name	Source charset	Target charset 	Comments
> ============== ==============  ============   =============
>   GBKTOUTF8          GBK2312              UTF8	When error occur during translation, SQL Error
> UTF8TOGBK             UTF8                    GB2312
> Internal
> Parser change
> Let class Translate support new translation-name.
> CodeGen change
> Translate::codeGen
> Executor change
> convDoIt



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)