You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Ravi Makwana <ra...@hotelhub.com> on 2020/06/05 11:30:35 UTC

Ignite SqlFieldQuery Unicode Characters Support

Hi,

We are using Apache ignite version 2.7 and we have one node cluster with
150 caches out of 150 We have 1 cache which contains Unicode characters
like Chinese language.

Server node is running on Linux OS & Client node is running on Windows OS.

Client side we are using sqlquery & sqlfieldquery to fetch and put &
data-streamer to insert data using .net ignite apis.

In ignite cache,we have AddressFull property which contains Unicode
characters like Chinese language so while inserting we have inserted
specified data into AddressFull property which is mentioned below.

*"北京市朝阳区安贞西里四区甲1号, 北京, 中国, 100011"*

While fetching data from ignite cache we have observed that we are not
getting inserted data properly.

We have performed below mentioned sqlquery using SqlFieldQuery.

SELECT HotelCode,AddressFull FROM HotelOtherLanguageMasterModel WHERE
HotelCode = '12345'

We got below mentioned result data for AddressFull property.

*"北京市�阳区安贞西里四区甲1�, 北京, 中国, 100011"*

Based on this test we have couple of questions on the same.

1) Is SqlFieldQuery .net api supporting Unicode characters?
2) If Yes, How do we overcome this issue?

Regards,
Ravi Makwana

Re: Ignite SqlFieldQuery Unicode Characters Support

Posted by Ravi Makwana <ra...@hotelhub.com>.
Hi,

We have started our ignite nodes (server & client) with mentioned jvm
parameter and it works fine.

Thanks for the quick response.

Regards,
Ravi Makwana

On Mon, 8 Jun 2020 at 18:49, Ilya Kasnacheev <il...@gmail.com>
wrote:

> Hello!
>
> I have met an error like this one, and my recommendation is that on all
> nodes, client and server, you should set file.encoding to the same value
> (UTF-8 usually, however CJK multi-byte encodings should also work).
>
> Make sure all of your JVMs are launched with -Dfile.encoding=UTF-8.
> ignite.sh should do that already. Make sure you are using the same on
> Windows and Linux.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пт, 5 июн. 2020 г. в 14:31, Ravi Makwana <ra...@hotelhub.com>:
>
>> Hi,
>>
>> We are using Apache ignite version 2.7 and we have one node cluster with
>> 150 caches out of 150 We have 1 cache which contains Unicode characters
>> like Chinese language.
>>
>> Server node is running on Linux OS & Client node is running on Windows OS.
>>
>> Client side we are using sqlquery & sqlfieldquery to fetch and put &
>> data-streamer to insert data using .net ignite apis.
>>
>> In ignite cache,we have AddressFull property which contains Unicode
>> characters like Chinese language so while inserting we have inserted
>> specified data into AddressFull property which is mentioned below.
>>
>> *"北京市朝阳区安贞西里四区甲1号, 北京, 中国, 100011"*
>>
>> While fetching data from ignite cache we have observed that we are not
>> getting inserted data properly.
>>
>> We have performed below mentioned sqlquery using SqlFieldQuery.
>>
>> SELECT HotelCode,AddressFull FROM HotelOtherLanguageMasterModel WHERE
>> HotelCode = '12345'
>>
>> We got below mentioned result data for AddressFull property.
>>
>> *"北京市�阳区安贞西里四区甲1�, 北京, 中国, 100011"*
>>
>> Based on this test we have couple of questions on the same.
>>
>> 1) Is SqlFieldQuery .net api supporting Unicode characters?
>> 2) If Yes, How do we overcome this issue?
>>
>> Regards,
>> Ravi Makwana
>>
>

Re: Ignite SqlFieldQuery Unicode Characters Support

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

I have met an error like this one, and my recommendation is that on all
nodes, client and server, you should set file.encoding to the same value
(UTF-8 usually, however CJK multi-byte encodings should also work).

Make sure all of your JVMs are launched with -Dfile.encoding=UTF-8.
ignite.sh should do that already. Make sure you are using the same on
Windows and Linux.

Regards,
-- 
Ilya Kasnacheev


пт, 5 июн. 2020 г. в 14:31, Ravi Makwana <ra...@hotelhub.com>:

> Hi,
>
> We are using Apache ignite version 2.7 and we have one node cluster with
> 150 caches out of 150 We have 1 cache which contains Unicode characters
> like Chinese language.
>
> Server node is running on Linux OS & Client node is running on Windows OS.
>
> Client side we are using sqlquery & sqlfieldquery to fetch and put &
> data-streamer to insert data using .net ignite apis.
>
> In ignite cache,we have AddressFull property which contains Unicode
> characters like Chinese language so while inserting we have inserted
> specified data into AddressFull property which is mentioned below.
>
> *"北京市朝阳区安贞西里四区甲1号, 北京, 中国, 100011"*
>
> While fetching data from ignite cache we have observed that we are not
> getting inserted data properly.
>
> We have performed below mentioned sqlquery using SqlFieldQuery.
>
> SELECT HotelCode,AddressFull FROM HotelOtherLanguageMasterModel WHERE
> HotelCode = '12345'
>
> We got below mentioned result data for AddressFull property.
>
> *"北京市�阳区安贞西里四区甲1�, 北京, 中国, 100011"*
>
> Based on this test we have couple of questions on the same.
>
> 1) Is SqlFieldQuery .net api supporting Unicode characters?
> 2) If Yes, How do we overcome this issue?
>
> Regards,
> Ravi Makwana
>