Re: UTF Problems

> 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
>
>