felixge/node-mysql — Issue #153: UTF
Author: dachev
Created: 2011-12-10 02:46:13+00:00
State: open

> show variables like "character_set_database";
utf8
> show variables like "collation_database";
utf8_unicode_ci
> CREATE TABLE test(id INT AUTO_INCREMENT, title TEXT) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

db.query('INSERT INTO test SET title=?', ['a \u2028 b']);

> SELECT title FROM test
a ? b