Unicode support for SqlParser

[Adam Hosek]

Hi,

The SqlParser does not support unicode chars in current version (nor in git master). For me it is a bug.

Queries like this always fail on unecpected character errors:

SELECT * FROM test WHERE c LIKE '%č%';
SELECT 'č';

The only change needed to support national chars via unicode is to add UNICODE_INPUT = true to the where.jj options section.

Please, add this to the next version.

//EDIT: patch moved to attachment

[Adam Hosek]

//EDIT: Attached patch moved to original post above. I didn't see the attachment button, sorry.

[Simon Chenery]

Logged as CsvJdbc bug #97, "Central European letters with diacritics do not work in SQL statements" and now marked as fixed.

I changed the Unicode characters in the unit test SQL statement to greater than 255 because your original unit test passed for me without the UNICODE_INPUT = true in where.jj.

Thank you for taking the time to report the problem and for providing a patch.

Next CsvJdbc version is planned for 08.12.2013.