Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

Collation Errors

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


dbmail at theplayboymansion

Jul 31, 2008, 2:42 AM

Post #1 of 2 (598 views)
Permalink
Collation Errors

Hi guys,

I've seen a couple of references but only a partially explained solution
- i'm getting this error when trying to add a user:

# dbmail-users -a henri -w test
euler dbmail-users[19696]: Error:[sql]
dbmysql.c,db_mysql_check_collations(+138): collation mismatch, your
MySQL configuration specifies a different charset than the data
currently in your DBMail database.
Failed. Could not connect to database (check log)

My database, 'dbmail' has collation type utf8-unicode which from
previous posts I thought was correct - can anyone tell me what the
correct collation type is?

Thanks,

Henri
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


dbmail at theplayboymansion

Jul 31, 2008, 2:50 AM

Post #2 of 2 (554 views)
Permalink
Re: Collation Errors [In reply to]

Very sorry, i just found out by trial and error that the required
collation is utf8_general_ci

Thanks,

Henri

Henri Cook wrote:
> Hi guys,
>
> I've seen a couple of references but only a partially explained
> solution - i'm getting this error when trying to add a user:
>
> # dbmail-users -a henri -w test
> euler dbmail-users[19696]: Error:[sql]
> dbmysql.c,db_mysql_check_collations(+138): collation mismatch, your
> MySQL configuration specifies a different charset than the data
> currently in your DBMail database.
> Failed. Could not connect to database (check log)
>
> My database, 'dbmail' has collation type utf8-unicode which from
> previous posts I thought was correct - can anyone tell me what the
> correct collation type is?
>
> Thanks,
>
> Henri
> _______________________________________________
> DBmail mailing list
> DBmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.