You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "AnSec.Biyuhao (JIRA)" <ji...@apache.org> on 2015/06/25 03:46:04 UTC

[jira] [Created] (PHOENIX-2073) Two bytes character in LIKE expression is not allowed

AnSec.Biyuhao created PHOENIX-2073:
--------------------------------------

             Summary: Two bytes character in LIKE expression is not allowed
                 Key: PHOENIX-2073
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2073
             Project: Phoenix
          Issue Type: Bug
            Reporter: AnSec.Biyuhao


If you use some two bytes character like Chinese characters in like expression, you will get a SQLException.

SELECT * FROM TEST.TEST WHERE name LIKE '中文%';

java.sql.SQLException: ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters (中文)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)