[jira] [Commented] (CALCITE-2616) Can't create Unicode literal by RelBuilder

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16643777#comment-16643777 ] 

Julian Hyde commented on CALCITE-2616:
--------------------------------------

I believe you can create character literals with other character set names (and other collations) using RexBuilder.makeCharLiteral. And sure, we could make it a bit easier to do that from RelBuilder.

> Can't create Unicode literal by RelBuilder
> ------------------------------------------
>
>                 Key: CALCITE-2616
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2616
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.17.0
>            Reporter: Anton Haidai
>            Assignee: Julian Hyde
>            Priority: Major
>
> Test in RelBuilderTest to reproduce the issue:
> {code:java}
> @Test public void testScanWithFilterByUnicodeValue() {
>   final RelBuilder builder = RelBuilder.create(config().build());
>   RelNode root =
>       builder.scan("EMP")
>           .filter(
>               builder.call(SqlStdOperatorTable.EQUALS,
>                   builder.field("ENAME"),
>                   builder.literal("Петро ピーター")
>               )
>           )
>           .build();
> }
> {code}
>  Result:
> org.apache.calcite.runtime.CalciteException: Failed to encode 'Петро ピーター' in character set 'ISO-8859-1'
> Possible workaround: create saffron.properties with the following property
> saffron.default.charset=UTF-16LE
> But UTF-8 will not work as a value of this property, see SqlUtil.translateCharacterSetName
> Related code:
>  * SqlUtil.translateCharacterSetName(charsetName)
>  * RelDataTypeFactoryImpl.getDefaultCharset()
>  * SaffronProperties
>  Could it be considered to switch defaults from "ISO-8859-1" to "UTF-8" in SaffronProperties?
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)