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

Daniel Lo Nigro lists at dan.cx
Wed Sep 12 02:38:14 UTC 2012


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 at gmail.com> 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
> 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.
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ximian.com/pipermail/mono-list/attachments/20120912/958a6471/attachment.html>


More information about the Mono-list mailing list