Anton Haidai created CALCITE-2616: ------------------------------------- Summary: 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
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 -- This message was sent by Atlassian JIRA (v7.6.3#76005)