unicode (urdu in yii)

OK I rebuilt the database as utf8 and all my tables are also utf8 (see below) but I still get the problem when I have the ‘charset’=>‘utf8’ in my config for the database but commenting that out works fine. If my database is utf8 and my tables are utf8, shouldn’t my columns be utf8 by default? Do I still need to specify each and every column? :( That just seems ridiculous!




mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S

    -> WHERE schema_name = "xxxxxxxx";

+----------------------------+

| default_character_set_name |

+----------------------------+

| utf8                       |

+----------------------------+

1 row in set (0.00 sec)





mysql> show table status

    -> ;

+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+

| Name            | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation       | Checksum | Create_options | Comment |

+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+

| profiles        | InnoDB |      10 | Compact    |    7 |           2340 |       16384 |               0 |            0 |   3145728 |           NULL | 2010-12-04 18:50:09 | NULL                | NULL                | utf8_general_ci |     NULL |                |         |

| profiles_fields | MyISAM |      10 | Dynamic    |    5 |            177 |         888 | 281474976710655 |         9216 |         0 |              6 | 2010-12-04 18:50:09 | 2010-12-04 18:50:09 | 2010-12-04 18:50:09 | utf8_general_ci |     NULL |                |         |

| quran_text      | MyISAM |      10 | Dynamic    | 6236 |            456 |     2845928 | 281474976710655 |        65536 |         0 |           6237 | 2010-12-04 18:50:28 | 2010-12-04 18:50:28 | NULL                | utf8_general_ci |     NULL |                |         |

| surahs          | InnoDB |      10 | Compact    |  114 |            143 |       16384 |               0 |            0 |   3145728 |           NULL | 2010-12-04 18:50:09 | NULL                | NULL                | utf8_general_ci |     NULL |                |         |

| tracked_surahs  | InnoDB |      10 | Compact    |   41 |            399 |       16384 |               0 |        49152 |   3145728 |            124 | 2010-12-04 18:50:10 | NULL                | NULL                | utf8_general_ci |     NULL |                |         |

| users           | InnoDB |      10 | Compact    |    6 |           2730 |       16384 |               0 |        65536 |   3145728 |             15 | 2010-12-04 18:50:10 | NULL                | NULL                | utf8_general_ci |     NULL |                |         |

| users_old       | InnoDB |      10 | Compact    |    3 |           5461 |       16384 |               0 |            0 |   3145728 |              4 | 2010-12-04 18:50:10 | NULL                | NULL                | utf8_general_ci |     NULL |                |         |

+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+

7 rows in set (0.01 sec)