Return-Path: <caché>
Received: by 10.54.133.5 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: 80.72.33.166 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;
h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
b=RyHac5NgicobkvvccmSUpxpSUnRUmeLLyQ327pACQaKBq1in9+4ZWlabzxqpSsWkgwrC88mteAp2TnnUgw4lXl0bwPJpv64Q7AZdxKVIVCSuHVoYvb92+u+xmntuDUPRF+I4MSn2IAFui1krCgWb5lhFiPDtPs/o/X/w8jXdwo0=
Content-Disposition: inline
References: <caché>
X-BeenThere: caché
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: "CiviCRM: General discussion around development"
<crm-dev.lists.objectledge.net>
List-Unsubscribe: <
http://lists.objectledge.net/mailman/listinfo/crm-dev>, <mailto:caché?subject=unsubscribe>
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>, <mailto:caché?subject=subscribe>
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
different.
* 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
MySQL.
...dave
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
caché
http://lists.objectledge.net/mailman/listinfo/crm-dev