Msg#: 4351817 posted 1:41 pm on Aug 18, 2011 (gmt 0)
I did try to change just the Letter field in the table to utf8 but got the same issue.
I probably will convert the whole database to utf8 the next time I re-run my scripts on all the tables, thanks. At the moment I've just dropped the unique property of the Letter feild - which allows me to insert the two seperate versions of 'e'/'é' (and similar) without any issues.
I suspect it might result in a few issues though a script or two further ahead when I try to do SELECT statements looking for "LIKE %<character>%" for each character.