liu ming created TRAFODION-1720:
-----------------------------------
Summary: 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
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)
