« Return to Thread: UTF Problems

UTF Problems

by Andrés Villanueva :: Rate this Message:

Reply to Author | View in Thread

Hi!
I have a problem when adding/updating a table that has a column with
UTF-8 collation.

The situation:
    All my tables are in latin1, but a few of them, need to store data
in for different languages.
In all those tables I have a column for english, french, russian and
spanish. As I said before, all collumns and all tables are set to use
latin1 as default, but the columns for the russian language where set to
use a utf8 collation.

The problem:
    When I copy/paste into the query browser, the data is stored
correctly, and the .net datagrids show the data correctly as well.
    The problem is that whenever I update / insert new data from the
app, the russian values aren't recognized, resulting in corrupted data.

The question:
    What should I do? :D

Any help will be much appreciated.

Thanks
Andr?s Villanueva


--
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/dotnet
To unsubscribe:    http://lists.mysql.com/dotnet?unsub=lists@...

 « Return to Thread: UTF Problems