Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Dean H. Saxe
October 28, 2009 3:50 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: MySQL Error Yes to what has been said. Collation needs to be same. I use utf8_general_ci and make sure that all tables and columns use that as well as the DB itself. If you don't have "alter"

RE: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Cody Wehunt
e, is there a way to make all text columns match w/o doing it by hand? Thanks, Cody From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy Sent: Wednesday, October 28, 2009 3:50 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: MySQL Error Y

Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Derrick Peavy
Yes to what has been said. Collation needs to be same. I use utf8_general_ci and make sure that all tables and columns use that as well as the DB itself. If you don't have "alter" permissions, you can't do anything about this. Maybe ask the admin to make the change? _

Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Kevin Pepperman
t did not work. > > alter table `mytable_*' convert to character set utf8 collate > utf8_general_ci; > > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Kevin > Hellriegel > Sent: Wednesday, October 28, 2009 2:21 PM > To: discu

Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Kevin Hellriegel
alf Of Kevin Hellriegel > Sent: Wednesday, October 28, 2009 2:21 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] OT: MySQL Error > > Whoops, forgot to include a link to a thread on the MySQL forums: > > http://forums.mysql.com/read.php?26,6528,6528#msg-6528 > >

RE: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Cody Wehunt
iegel Sent: Wednesday, October 28, 2009 2:21 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: MySQL Error Whoops, forgot to include a link to a thread on the MySQL forums: http://forums.mysql.com/read.php?26,6528,6528#msg-6528 On Wed, Oct 28, 2009 at 2:20 PM, Kevin Hellriegel wrote: > I

RE: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Cody Wehunt
Thanks will get the host to look into. Unfortunately I don't have access to the server to make this change. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Kevin Pepperman Sent: Wednesday, October 28, 2009 2:32 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT:

Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Kevin Pepperman
Also check the mySql server collation . The default settings will always use latin1 latin1_swedish_ci unless the server collation is defined on startup. If you don't specify a character set, that is the same as saying > --character-set-server=latin1

Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Kevin Hellriegel
Whoops, forgot to include a link to a thread on the MySQL forums: http://forums.mysql.com/read.php?26,6528,6528#msg-6528 On Wed, Oct 28, 2009 at 2:20 PM, Kevin Hellriegel wrote: > I've run into this a few times. Basically it means the charsets in the > tables are different and MySQL doesn't like

Re: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Kevin Hellriegel
I've run into this a few times. Basically it means the charsets in the tables are different and MySQL doesn't like that. You're going to have to change the charset type in one of the tables to match the other. hth, Kevin On Wed, Oct 28, 2009 at 2:14 PM, Cody Wehunt wrote: > Anyone have any info

RE: [ACFUG Discuss] OT: MySQL Error

2009-10-28 Thread Cody Wehunt
Version 5.0.18 From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cody Wehunt Sent: Wednesday, October 28, 2009 2:15 PM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: MySQL Error Anyone have any information on the following error: General error: Illegal mix of collations