Non-English charset support for Druid Jdbc.

[fanwu72]

Hi team,

The below SQL returns nothing while running with Druid Jdbc.
However it returns some rows when I change to use Druid Restful API.

select cache_group, count(1) from table where cache_group = '北京NEW' group by cache_group

When I remove the condition where cache_group = '北京NEW' rows are returned as expected.

I know that Druid Jdbc is a experimental feature but I will be very happy if someone can figure out the problem and fix this issue.

I am using druid-0.12.1

Best regards,
Ryan

[stale]

This issue has been marked as stale due to 280 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If this issue is still relevant, please simply write any comment. Even if closed, you can still revive the issue at any time or discuss it on the dev@druid.apache.org list. Thank you for your contributions.

[gianm]

@fanwu72 are you still facing this issue with the latest Druid? I haven't looked into it yet, but wondering if it's still relevant. Any interest in contributing a unit test that demonstrates the problem? We could add it to the code base with an @Ignore tag just so we have it and can use it to verify if this is fixed in the future.

[stale]

This issue is no longer marked as stale.

[stale]

This issue has been marked as stale due to 280 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If this issue is still relevant, please simply write any comment. Even if closed, you can still revive the issue at any time or discuss it on the dev@druid.apache.org list. Thank you for your contributions.

[stale]

This issue has been closed due to lack of activity. If you think that is incorrect, or the issue requires additional review, you can revive the issue at any time.

[BigRantLing]

Before you execute the sql, you can recode it to iso88591,like below:

        String sql = "select cache_group, count(1) from table where cache_group = '北京NEW' group by cache_group";
        String recodeSql = new String(sql.getBytes(), Charsets.ISO_8859_1);
        ResultSet result = statement.executeQuery(recodeSql);

I think this will solve your problem@fanwu72