[grazzy]

mysql> show create table test\G
*************************** 1. row ***************************
    Table: test
Create Table: CREATE TABLE `test` (
 `id` int(11) NOT NULL auto_increment,
 `title` varchar(255) default NULL,
 PRIMARY KEY (`id`)
) TYPE=MyISAM
1 row in set (0.00 sec)

mysql> insert into test values(7,'café');
Query OK, 1 row affected (0.00 sec)

mysql> select * from test where title = 'cafe';
+----+-------+
| id | title |
+----+-------+
| 7 | café |
+----+-------+
1 row in set (0.00 sec)

mysql> select * from test where title like 'cafe'; 
+----+-------+
| id | title |
+----+-------+
| 7 | café |
+----+-------+
1 row in set (0.00 sec)

mysql> show variables like '%char%'\G
*************************** 1. row ***************************
Variable_name: character_set
    Value: latin1
*************************** 2. row ***************************
Variable_name: character_sets
    Value: latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
*************************** 3. row ***************************
Variable_name: convert_character_set
    Value: 
3 rows in set (0.00 sec)

Så, "ja".