[Mono-list] Mono/odbc passing invalid chars to MySQL DB

[BadRobot]

Ok, firstly, forgive me, as I'm far from experienced with these kind of
things :)

I've got a Procon gameserver controller
(http://phogue.net/procon-frostbite/) running on mono 2.6.7 on Debian 6
squeeze.
Procon has a player stats & chat logger, via a plugin, which sends player
data to a mysql (5.1.63) db. with unixodbc 2.2.14, & MySQL connector 5.1.11,
I have also tried MySQL connector 5.1.9
It should be noted however, that the issue persists with Unbuntu 12.04, Mono
2.10.8.1 & unixodbc 2.2.14 

I've moved the Procon setup from a Windows machine, where its been working
great for months, & apart from the this logging problem, seems to be fine on
top of mono.

So, what is happening? Instead of filling the db with playernames & chat log
entries, its filling it with invalid chars. All data to be logged is English
with no unusual characters.
Previous db entries while running on Windows display correctly on the stats
website, new entries while running on Mono do not.

When the procon plugin & sql db were all at default Latin1, it filled the db
with just questionmarks, so I assumed a charset issue, changed all
references of Latin1 to UTF8 in the Procon plugin source (its compiled on
the fly at launch), and set MySQL to UTF8, and now it fills the db with
Asian/Chinese characters....

I've spent a long time with Google, and come to the conclusion somewhere the
correct encoding or line endings are not being translated somehow either by
Mono, or the unixodbc driver, but its a little above my head & I could be
miles off the mark.

Can anyone give me some suggestions on how to fix this?
Thanks.





--
View this message in context: http://mono.1490590.n4.nabble.com/Mono-odbc-passing-invalid-chars-to-MySQL-DB-tp4656587.html
Sent from the Mono - General mailing list archive at Nabble.com.