mysql: issues with varchar columns -- is it an encoding thing?

[christi...@gmail.com]

I managed to get everything built on ubuntu (using , but I am getting
funny output from a simple script:

(the jstest table only has one column, name)

x@xtian:~/wxjs/Release 0.9.74/wxJS2/bin/Debug$ ./wxJS -m modules.js
test.js
one뜀犘
two뜀
three
ooone
two뜀
three

Here is the script (test.js):

var db = new mysql.Database();
if ( db.connect("localhost", "x", "woohoo", "x") )
{

db.query("DELETE FROM jstest");
db.query("INSERT INTO jstest VALUES ('one'),('two'),('three')");

var stmt = db.query("SELECT name from jstest;");
var row;
while(row = stmt.fetchObject())
{
print(row.name);
print("\n");
}

db.query("UPDATE jstest SET name='ooone' where name='one'");
var stmt = db.query("SELECT name from jstest;");
var row;
while(row = stmt.fetchObject())
{
print(row.name);
print("\n");
}
}

What am I doing wrong?

[franky...@gmail.com]

I'll try to investigate your problem this week.

Franky

[Franky Braem]

christi...@gmail.com schreef:

I've tested your script (on Windows) and don't see the weird characters.
What's the character set used by the table jstest?

Franky.