[Mono-list] Mono/odbc passing invalid chars to MySQL DB
robster400 at gmail.com
Wed Sep 12 14:34:23 UTC 2012
The software is limited to odbc I believe, although, as a layman, don't take
my word on that...
I've uploaded the source for the plugin, remember that its compiled on the
fly at launch by the Procon application itself, and I am unable to supply
any build flags (unless I'm overlooking something) for the plugin as
the Connection strings are around line 2791
I am unsure if anything can be modified to adapt to using the .net connector
& the developer is unwilling to supply any support due to the unnatural
environment I assume.
Daniel Lo Nigro wrote
> Since you mentioned unixodbc, I assume you're using the ODBC MySQL
> connector. Is there any particular reason for this? Is it a limitation of
> the software you're using (does it only support ODBC)?
> Have you tried the native .NET connector instead? It's a fully-managed
> ADO.NET driver which doesn't require ODBC, and works with Mono. If you can
> set the ADO.NET database provider the application uses, you should be able
> to use it. See http://dev.mysql.com/downloads/connector/net/#downloads
> On Wed, Sep 12, 2012 at 10:34 AM, BadRobot <robster400@> wrote:
>> 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
>> 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
>> I have also tried MySQL connector 5.1.9
>> It should be noted however, that the issue persists with Unbuntu 12.04,
>> 18.104.22.168 & unixodbc 2.2.14
>> I've moved the Procon setup from a Windows machine, where its been
>> great for months, & apart from the this logging problem, seems to be fine
>> top of mono.
>> So, what is happening? Instead of filling the db with playernames & chat
>> entries, its filling it with invalid chars. All data to be logged is
>> with no unusual characters.
>> Previous db entries while running on Windows display correctly on the
>> website, new entries while running on Mono do not.
>> When the procon plugin & sql db were all at default Latin1, it filled the
>> 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
>> correct encoding or line endings are not being translated somehow either
>> 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?
>> View this message in context:
>> Sent from the Mono - General mailing list archive at Nabble.com.
>> Mono-list maillist - Mono-list at .ximian
> Mono-list maillist - Mono-list at .ximian
View this message in context: http://mono.1490590.n4.nabble.com/Mono-odbc-passing-invalid-chars-to-MySQL-DB-tp4656587p4656598.html
Sent from the Mono - General mailing list archive at Nabble.com.
More information about the Mono-list