On Thu, 13 Mar 2008 17:29:45 +0100, Aljosa Mohorovic
<aljosa.mohorovic@gmail.com> wrote:

> if i have database named TESTDB and i'm storing utf8 data into this
> latin1 TESTDB database is there a way that i can convert database to
> utf8?

Just make the field in the table utf8, nothing else really matters.
(Except connections should be told they work in utf8 ofcourse).

> what happens with utf8 data when it is stored into latin1 database?

No idea, I'd assume they're maimed.

> Client characterset: latin1
> Conn. characterset: latin1

...should be utf8 if you want to work with it.
--
Rik Wasmus