You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/03/23 09:05:25 UTC
[jira] [Commented] (TRAFODION-1720) add GBK support in SQL
translate function
[ https://issues.apache.org/jira/browse/TRAFODION-1720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15208028#comment-15208028 ]
ASF GitHub Bot commented on TRAFODION-1720:
-------------------------------------------
GitHub user traflm opened a pull request:
https://github.com/apache/incubator-trafodion/pull/400
[TRAFODION-1720] rework, fix a bug in it
simulate the same behavior as UTF8. When there are full-width chars, this change will work as well.
test with:
REAL
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/traflm/incubator-trafodion TRAFODION-1720-rework
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/400.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #400
----
commit f9fdf8d19582575f49c6241af709c5785765b979
Author: Liu Ming <ov...@sina.com>
Date: 2016-03-23T06:53:44Z
[TRAFODION-1720] rework, fix a bug in it
----
> 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)