| Jim Rea
                                                                                                                             
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Monday 30 January 2006 4:41:27 pm 
                                                                
                                                                 I have read a great deal on these forums regarding the characterset not being accepted during installation, to no avail. I still cannot get past this check in the installation script. I submitted the following MySQL query which was successfully executed: ALTER DATABASE `ezpub` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci 
The database characterset reads as being set to utf8I have selected eng-US as the language
 Still I cannot get past this problem in the script. The MySQL manual indicates that the statement above will change the default character set, and it appears to have done so. I do not understand why the check continues to fail. Help from anyone would be greatly appreciated | 
                                                
                                                                                                                                                        
                                                        | Jim Rea
                                                                                                                             | Wednesday 01 February 2006 12:48:33 am 
                                                                 Hi Xavier, I am running PHP 4.3.10 and MySQL 3.23.58 My settings are a little different from my original post as I am continuing to experiment. I am in the installation script, having selected eng-GB as the language. At the Site Details screen after selecting the database mentioned above I get the following message:  Warning  The database cannot be used, it uses the character set which is different from the requested charset iso-8859-1, iso-8859-2, iso-8859-3, iso-8859-4, iso-8859-9, iso-8859-10, iso-8859-13, iso-8859-14, iso-8859-15, windows-1252, windows-1250, cp850, dec-mcs. The current character set is (on this iteration) latin1 latin1_bin - which I understand from other postings on this forum is aliased to iso-8859-1. Thanks for your help | 
                                                                                                    
                                                        | arran holloway
                                                                                                                             | Friday 16 June 2006 8:16:29 am 
                                                                 I am also having exactly the same problems as reported above, has anybody found a solution to this problem yet? My database name uses _-_ in the middle of it (a name format imposed by hosting) other people have reported problems with this that may be related to the characterset problem. | 
                                                                                                    
                                                        | Björn X
                                                                                                                             | Friday 16 June 2006 9:55:53 am 
                                                                 Well it is very easy.... you need mysql 4.1 and above ALTER DATABASE `ezpub` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci won't execute below 4.1, meaning 4.1 onyl has real unicode support  |