Re: Encoding problem in WHERE LIKE

Hi, Dongwon ~ > Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at > line 1, column 96.  Encountered The error did report the position, you can take a reference to see which syntax context caused the problem. Best, Danny Chan 在 2020年7月20日 +0800 PM11:10，Dongwon Kim ，写道

Re: Encoding problem in WHERE LIKE

Hi Leonard, You're right; I was missing a single quotation mark before the LIKE. There's no encoding problem at all! Sorry for the confusion. Thanks, Dongwon On Tue, Jul 21, 2020 at 12:00 AM Leonard Xu wrote: > Hi, Kim > > The clause ` LIKE '%양현마을%’ ` should work well, could you post the t

Re: Encoding problem in WHERE LIKE

Hi, Kim The clause ` LIKE '%양현마을%’ ` should work well, could you post the the entire query(or select clause) ? Best Leonard Xu > 在 2020年7月20日，21:49，Dongwon Kim 写道： > > When I execute the following query in .sqlQuery(), > SELECT ... > FROM ... > WHERE location.goalName LIKE '%양현마을%'

Encoding problem in WHERE LIKE

Hi, When I execute the following query in .sqlQuery(), > SELECT ... > FROM ... > WHERE location.goalName LIKE '%양현마을%' > I got the following error message > Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error > at line 1, column 96. Encountered: "\uc591" (50577), after : "