UTF-8

[adw999]

Hi

I'm currently updating all my tables to support utf-8 unicode ci encoding and everything has gone well so far (touch wood); all the tables updated via phpmyadmin fine.

The changes have been made to support different languages for a program i distribute therefore I complied all the SQL operations used. I went to test the SQL to make sure others could run it fine but when performing, it throws the error:

1054 - Unknown column 'password' in 'users'

Which comes from the line:

CHANGE `password` `password` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

(In amongst other changes in an alter instruction). The row definitely exists so what am i doing wrong? The field holds md5 passwords if thats something to do with it??

Thanks
Ashley