[No Subject]

Objet:   [No Subject] (trouver plus)
Date:   Dec 08, 2005 13:56

Return-Path: <caché>
Received: by chastell.shot.pl (Postfix, from userid 1000)
 id 1958540EB7; Thu,  8 Dec 2005 13:56:38 +0100 (CET)
Message-ID: <caché>
Date: Thu, 8 Dec 2005 13:56:38 +0100
From: Piotr Szotkowski <caché>
Reply-To: "CiviCRM: General discussion around development" <caché>
Sender: caché
To: caché
Subject: Re: [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: Thu, 08 Dec 2005 07:56:56 -0500
X-Forwarded-To: caché
X-Forwarded-For: caché caché
X-Gmail-Received: 7ae2e711b605c332c02d85063aefab5689f659aa
Delivered-To: caché
Received-SPF: neutral (gmail.com: is neither permitted nor denied by best guess record for domain of caché)
Old-Return-Path: <caché>
References: <caché>
Content-Disposition: inline
Organization: OpenNGO
X-PGP-Key: http://shot.pl/pubkey.asc
X-PGP-Key-ID: 0xD128F14A
X-Operating-System: Debian GNU/Linux, up 65 days, 21:58
User-Agent: Mutt/1.5.11
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é


Olivier Boulot:

> I spent some time a couple of days ago using TOAD/mysqladmin and
> creating scripts with alter database, alter table to no avail.

Er, right. I just checked in PHPMyAdmin, and changing the database's
collation is not enough. :o| On the other hand, if at install time
I create the database with proper collation, the tables inherit
the collation properly (as the Drupal SQL file does not specify
any collation explicitely, the tables inherit the database's
collation upon CREATE TABLE calls).

Sorry for the confusion. I'm not sure there's an easy way
(a simple SQL command not listing all of the tables by name)
to change the tables' collation once they're created. :o(

-- Shot
         The general rule about people on IRC seems to be 'Attractive,
         single, mentally stable: choose two.'           -- malaclypse
====================== http://shot.pl/hovercraft/ === http://shot.pl/1/125/ ===
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.