wrong charset
Posted: 05. February 2005 00:18
How do i change the charset UTF-8 Unicode (utf8) into English en-iso-8859-1
When I export an sql file it looks like this
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
When i export from myphpadmin from my webhost it looks like this:
TYPE=MyISAM AUTO_INCREMENT=1 ;
Can somebody please tell me how to change the charset and how to disable the charset and the collate tags in the sql file ?
I get syntax errors when i try to upload to my webhost
When I export an sql file it looks like this
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
When i export from myphpadmin from my webhost it looks like this:
TYPE=MyISAM AUTO_INCREMENT=1 ;
Can somebody please tell me how to change the charset and how to disable the charset and the collate tags in the sql file ?
I get syntax errors when i try to upload to my webhost