Query Using Chinese Characters Returns No Results

Question

Query Using Chinese Characters Returns No Results

the-notable Feb '14

Created Feb '14	Last Reply None	Replies 0	Views 1042	Votes 0

the-notable 1.3k

Feb '14

Target table has two columns: one column of unique Chinese characters, the other column is unique int acting as the primary key. I'm trying to return the key corresponding to a given character.

Returns 0 results:

$value = "好";
$character_id = self::query()
    ->where("character = :character:")
    ->bind(array("character" => $value))
    ->execute();

Returns 0 results (using single quotes around the character):

$character_id = self::query()
    ->where("character = '好'")
    ->execute();

Returns error (using no quotes around the character): Scanning error before '��' when parsing: SELECT [Characters].* FROM [Characters] WHERE character = 好

$character_id = self::query()
    ->where("character = 好")
    ->execute();

If I query against the primary key column using an existing key it returns results, so I'm thinking this is an encoding issue. Has anyone else run into this problem?

the-notable
1.3k

Accepted
answer

Feb '14

For anyone else having this problem, the solution can be found on stackexchange here:

https://stackoverflow.com/questions/21688981/cannot-return-chinese-characters-from-mysql-using-phalcon/21695837#21695837

the-notable · Answer 1 · 2014-02-08T17:51:30-07:00

I've tried running the query directly using sql. I've discovered "character" is a keyword in mysql, so by adding backticks around the column name, and quotes around the character itself, mysql will return results. However, I do not know how to implement this in phalcon, as the following code still produces an error: PhalconException: Scanning error before 'character = '�...' when parsing: SELECT [Characters].* FROM [Characters] WHERE character = '好' (65)

->where("`character` = '好'")