i used to have the DB on mysql 4.1 on the previous server which had CHARSET=latin1, but the new server runs mysql 4.0.x which does not support CHARSET, so i removed the CHARSETs as per a link google gave me. is there no work around without using CHARSETs?