different charset?

With a little experimentation, I changed mysql's default
from latin1 to utf8.  None of my existing applications were
bothered by this change.  I then re-created the dbmail
database and dbmail worked fine.


Thanks, everyone, for your help!

-- 
Michael Henry (Mike)
Westminster, CO

   From now on, I'll connect the dots my own way.
		  -- Calvin

On Tue, Jul 25, 2006 at 09:57:51PM +0100, Jorge Bastos
wrote:
> Hum... the database can have a diferent charset than
the tables
> check that, i think is that
> 
> 
> 
> ----- Original Message ----- From: "Michael
Henry" <mhenryneocrime.com>
> To: "DBMail mailinglist" <dbmaildbmail.org>
> Sent: Tuesday, July 25, 2006 8:10 PM
> Subject: Re: [Dbmail] different charset?
> 
> 
> >the database is configured for latin12, there is no
specification within the SQL supplied in the dbmail package.
 Therefore I assume they 
> >match.
> >
> >Am I incorrect?
> >
> >-- 
> >Michael Henry (Mike)
> >Westminster, CO
> >Mobile:  303-717-4489
> >
> >"He dropped his voice still lower. In the
stillness, a fly
> >would not have dared cleat its throat. "
> >
> >On Tue, Jul 25, 2006 at 07:53:23PM +0100, Jorge
Bastos wrote:
> >>Do you have the database charset equal to the
tables charset?
> >>
> >>
> >>----- Original Message ----- From:
"Michael Henry" <mhenryneocrime.com>
> >>To: <dbmaildbmail.org>
> >>Sent: Tuesday, July 25, 2006 7:40 PM
> >>Subject: [Dbmail] different charset?
> >>
> >>
> >>>This is an error from a new installation of
dbmail 2.1.6.
> >>>
> >>>Jul 25 10:35:49 intzeus dbmail/user[1497]:
>dbmysql.c,db_mysql_check_collations: collation mismatch,
your MySQL >configuration 
> >>specifies a different charset than the data
currently
> >>>in your DBMail database.
> >>>
> >>>Considering I just loaded the database from
the supplied >dbmail-2.1.6/sql/mysql/create_tables.mysql
and have not changed the >database 
> >>configuration since that time, I am assuming
> >>>there is a bug in dbmail.  Figured I'd
asked the dbmail list for advice >first, however.
> >>>
> >>>Oh yeah, using mysql 4.1.19.  Upgrading to
4.1.20 at this moment.  Can't >upgrade to 5 due to
issues with other software which a client 
> >>requires >me to run (ugh!)
> >>>
> >>>I've used dbmail 2.0.x on a similar
configured server without running >across this error.
> >>>
> >>>Any ideas how to fix this problem?
> >>>
> >>>Thanks for your time!
> >>>
> >>>-- >Michael Henry (Mike)
> >>>Westminster, CO
> >>>
> >>>Janitor: Oh, marmalade!
> >>>
>
>>>_______________________________________________
> >>>Dbmail mailing list
> >>>Dbmaildbmail.org
> >>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>
> >>_______________________________________________
> >>Dbmail mailing list
> >>Dbmaildbmail.org
> >>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >_______________________________________________
> >Dbmail mailing list
> >Dbmaildbmail.org
> >htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail