Re: Ignite SqlFieldQuery Unicode Characters Support
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 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 : > >> 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
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 : > 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 >
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