<?php

require_once dirname(__FILE__) . "/../../../src/PHPSQLParser.php";
require_once dirname(__FILE__) . "/../../test-more.php";

// TODO: not solved, charsets are not possible at the moment
$parser = new PHPSQLParser();

$sql = "SELECT _utf8'hi'";
$parser->parse($sql, false);
$p = $parser->parsed;
$expected = getExpectedValue(dirname(__FILE__), 'issue50.serialized');
eq_array($p, $expected, 'does not die if query contains _utf8');


$sql = "SELECT _utf8'hi' COLLATE latin1_german1_ci";
$parser->parse($sql, false);
$p = $parser->parsed;

# hex value

$sql = "SELECT _utf8 x'AABBCC'";

$sql = "SELECT _utf8 0xAABBCC";

# binary value
$sql = "SELECT _utf8 b'0001'";

$sql = "SELECT _utf8 0b0001";

?>
