Re: sql parser encoding

[Venki Korukanti]

How about replacing '台北' with _UTF16'台北' in your query?

On Thu, Mar 19, 2015 at 2:44 AM, Wang Darrell <darrellwan...@gmail.com>
wrote:

> there is still some encoding problem
> First I encoding '台北' into this '&#21488;&#21271;'
> then Drill has no problem with it then send the query to mongoDB.
> But when mongodb process this query ,
>
> 2015-03-19T02:36:43.006-0700 I QUERY    [conn2] query test.zips query: {
> city: { $eq: "&#21488;&#21271;" } } planSummary: COLLSCAN ntoreturn:0
> ntoskip:0 nscanned:0 nscannedObjects:29360 keyUpdates:0 writeConflicts:0
> numYields:229 nreturned:0 reslen:20 locks:{} 113ms
>
> it show this: query test.zips query: { city: { $eq: "&#21488;&#21271;" } }
>
> so there is no result , because it look up the data with
>  "&#21488;&#21271;"  not "台北"
>
> How can I encoding my query that can satisfy the apache drill and the
> mongodb both ?
>