[
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)
