[No Subject]

Objet:   [No Subject] (trouver plus)
Date:   Dec 07, 2005 20:43

Return-Path: <caché>
Received: by with HTTP; Wed, 7 Dec 2005 11:43:35 -0800 (PST)
Message-ID: <caché>
Date: Wed, 7 Dec 2005 11:43:35 -0800
From: Dave Greenberg <caché>
Reply-To: "CiviCRM: General discussion around development" <caché>
Sender: caché
To: CiviCRM Developer Community <caché>,
  Civicspace <caché>
Subject: [Crm-dev] Re: [CS dev] Illegal Mix of Collations
In-Reply-To: <caché>
Errors-To: caché
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Delivery-Date: Wed, 07 Dec 2005 14:44:11 -0500
X-Forwarded-To: caché
X-Forwarded-For: caché caché
X-Gmail-Received: 17c9769b15f46c4e26a4c73241dcbdf6a6da74f4
Delivered-To: caché
Received-SPF: neutral (gmail.com: is neither permitted nor denied by best guess record for domain of caché)
DomainKey-Status: bad (test mode)
Old-Return-Path: <caché>
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
Content-Disposition: inline
References: <caché>
X-BeenThere: caché
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: "CiviCRM: General discussion around development"
List-Unsubscribe: <http://lists.objectledge.net/mailman/listinfo/crm-dev&gt;,
List-Archive: <http://lists.caltha.pl/pipermail/crm-dev>
List-Post: <mailto:caché>
List-Help: <mailto:caché?subject=help>
List-Subscribe: <http://lists.objectledge.net/mailman/listinfo/crm-dev&gt;,
Envelope-To: caché

Greg / Oliver...
We've investigated this collation problem a bit, and don't have a
universal fix yet - there are lots of variables including different
behaviors in different MySQL versions, default collation settings,
etc. However...some answers and potential work-arounds:

* Some versions of MySQL use latin-1-swedish as the default collation.
If Drupal tables are created in these versions - they will carry that
collation. What version of MySQL are u running?

* There is a case modify operation in the interface between Drupal and
CiviCRM and this is what causes the error if the collations are

* I don't know of a batch way to change the collations of all tables
in a DB in phpMyAdmin - altho there may be one. Let us know if you
find out. Alternatively, you could create a script which retrieves all
the Drupal DB tables and then loops through them w/ the ALTER TABLE
command to modify the collations.

* If you aren't planning on using i18n features in CiviCRM - you can
install it with the MySQL 4.0 table create script (civicrm_40.mysql) .
This doesn't specify the utf-8 collation - so will use the default in


On 12/7/05, Gregory Heller <caché> wrote:
> I installed Civicspace 0.8.2rc6 on dreamhost, then added a few modules,
> then when registering new users or e3diting users i got illegal mix of
> collation errors.  it seems that a bunch of my civicspace/drupal tables
> were created with swedish collation rather than utf8
> any ideas why this would have happend?  I went through and changed the
> collatiuon on the fields and tables that were returning errors but i
> still have other tables/fields that still ahve the swedish collation.
> is there a way to change all the collations easily through phpmyadmin
> rather than going through 100+tables and doing it manually?
> --
> ----
> Gregory Heller
> http://www.CivicActions.com
> http://www.GregoryHeller.com
> AIM/SKYPE: GregoryHeller
> The content of this email message is licensed under a
> Creative Commons Attribution-ShareAlike 2.5 License, Some Rights Reserved.
> http://creativecommons.org/licenses/by-sa/2.5/
> Get Firefox! The Browser you can trust http://www.mozilla.com
> Reclaim you inbox with Thunderbird! http://www.mozilla.com
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: caché
> For additional commands, e-mail: caché

Best regards,
Dave Greenberg
CiviCRM Team
Try CiviCRM - http://www.openngo.org
Crm-dev mailing list

Creative Commons License
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-Share Alike 3.0 United States Licence.