Thank you for your reply!
I'm a little scared of 'handmade' database-altering php scripts.
This will change the collation for ALL tables, right?
I made up a list of table names for 4.7 and am attaching them to this e-mail. Maybe someone will find it useful!
Anisa.
On 6/28/06, Sanduhrs <sanduhrs@audiens.de> wrote:
Ni Anisa,
I'm not a MySQL-Guru, but you may use something like the following in a simple
PHP enabled Drupal page:
<?php
global $db_url;
$database = parse_url($db_url);
$result = db_query('show tables');
while($tables = db_fetch_array($result)) {
foreach ($tables as $key => $value) {
db_queryd("ALTER TABLE %s COLLATE utf8_general_ci",$value);
}
}
?>
vg
Am Dienstag, 27. Juni 2006 16:53 schrieb Anisa:
> A lot of people, upgrading from 4.6 to 4.7, or having phpmyadmin issues,
> are interested in a script or some sort of file that will change the
> collation to utf8_general_ci on all tables. Anyone have any ideas? I want
> to add it to the handbook.
>
> I think it would be pretty easy to make a sql thingy for default tables,
> how do you deal with prefixes?
>
> Anisa.
> OOO! How about a list of tablenames in the handbook...
--
[ Drupal support list | http://lists.drupal.org/ ]
--
*********************************
www.AnimeCards.Org
16,000 scans and counting!
*********************************