Re: [ACFUG Discuss] OT: MySQL Error

You have it backwards. Latin-1 is only 256 characters, UTF-8 conceivably supports up to 4 million or so. Unless you have a need for internationalization, stick with latin-1. -dhs -- Dean H. Saxe "A true conservationist is a person who knows that the world is not given by his fathers, but

RE: [ACFUG Discuss] OT: MySQL Error

Ok, thanks everyone. For now I changed the offending columns to latin1 and latin1_swedish_ci b/c that seems to be what the server is dictating. And the error is gone. What are the cons for using latin1 over utf8? Foreign character support? If I can't get host to make the change, is th

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" permissions, you can't do anything about this. Maybe ask the admin to make the change? _

Re: [ACFUG Discuss] OT: MySQL Error

Its not the tables that are causing the issue. It is the collation of the individual columns. On Wed, Oct 28, 2009 at 2:42 PM, Cody Wehunt wrote: > Thanks I had already checked something similar but per the link below I > tried... > > alter table `tablename' convert to character set utf8 collate

Re: [ACFUG Discuss] OT: MySQL Error

Are you able to view the properties of the table? See if you can verify that both the table and the columns have the same charset. Also, instead of utf8_general_ci try utf8_swedish_ci. Kevin On Wed, Oct 28, 2009 at 2:42 PM, Cody Wehunt wrote: > Thanks I had already checked something similar but

RE: [ACFUG Discuss] OT: MySQL Error

Thanks I had already checked something similar but per the link below I tried... alter table `tablename' convert to character set utf8 collate utf8_general_ci; on all 3 tables referenced in the query that is failing and it still produces the same error. Any other ideas? Also if anyone has an ide

RE: [ACFUG Discuss] OT: MySQL Error

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: MySQL Er

Re: [ACFUG Discuss] OT: MySQL Error

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

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

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

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

[ACFUG Discuss] OT: MySQL Error

Anyone have any information on the following error: General error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'UNION' I am working on finding out from the host what version of MySQL is currently running. ---

re[2]: [ACFUG Discuss] Development vs Production Application.cfm and other things...

FWIW, I am creating application objects in application.cfc   application.Order = createobject("Component", #application.ComponentsLocation# & "Order");   this way CF doesn't have to create and destroy these static objects all the time. For development this doesn't work so well because you'd