Re: MYSQL doesn't 'see' accents

[Evi Wool]

Rick, you nearly cracked it!
I used the following command
ALTER TABLE TblEngTest CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

When I SELECT a line which I knew had an accent, the accent now displays correctly. To add to this, This database has an OpenOffice BASE front end. In BASE, before I ran this command, the accents did display correctly. I thought at first that all was well but when I ran a select query with the criteria
LIKE '%é%'
any word containing e was displayed rather than only words containg é
but after altering the table's Character set AND collate, the criteria now works properly.
I say it's nearly because there is still some difficulty with è and one or two other accents . They filter properly in BASE but displays incorrectly in MySQL yet if I edit it in MYSQL it displays incorrectly in BASE. but this is a big step;