Data Studio
5K members online now
5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Filter Field Non-English Text is broken

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I Use Data Studio with my own Mysql Database.

When I Use Some Text Field in Korean As Filter, No data is retrieved with that Filter.

In My Mysql Database Query Log, The filter text is broken like this.

 

SELECT AgentNm, SUM(PURE_REVENUE) AS _PURE_REVENUE_, COUNT(distinct ORDERID) AS calc_kjnwjloe FROM RENTORDER_STAT AS t0 WHERE (START_DATE >= '20170601' AND START_DATE <= '20170630' AND SIDO IN ('충북')) GROUP BY AgentNm ORDER BY _PURE_REVENUE_ DESC

 

The SIDO Value should be "충북", as shown in attached pic.ds2.png