| Author | Message | 
                                                                                                    
                                                        | Thomas Johannessen
                                                                                                                             
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Tuesday 23 May 2006 3:39:43 am 
                                                                
                                                                 
Issue:I have altered my DB to utf8, but I still get this message:
 
The database [xxx_-_38] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set []. You will have to choose a database having support for [utf-8] or modify [xxx_-_38] .
 
<b>So I ask you smart guys: What do I have to do then, when I change my DB to UTF-8, and I try with all of the utf-8 variants I can, no luck.</b>
 Soon I give up EZ.  www.taon.no
 
 | 
                                                
                                                                                                                                                        
                                                        | Vjeran Vlahovic
                                                                                                                             | Wednesday 24 May 2006 6:57:03 am 
                                                                 I had some strange similar issue like You... Try to remove - from the database name (rename xxx_-_38 to xxx38) and try again. http://www.netgen.hr/eng
                                                                 | 
                                                                                                    
                                                        | Thomas Johannessen
                                                                                                                             | Wednesday 24 May 2006 9:46:01 am 
                                                                 
Vjeran, I understand, but my created databases have the name:xxx_-_38 where the domain is: xxx = taon_-_38
 my creation is just 38, the system makes the rest... I can try but I do not think I can change the name.. www.taon.no
 
 | 
                                                                                                    
                                                        | Rod Pal
                                                                                                                             | Thursday 25 May 2006 2:20:09 pm 
                                                                 I have this very same issue. I'm not able to go beyond the "Site details" installation step, it says:    
 The database [uv0027_noticias] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [uv0027_noticias] 
  How could it be fixed? | 
                                                                                                    
                                                        | Ole M. Holden
                                                                                                                             | Monday 29 May 2006 11:14:09 pm 
                                                                 I've got the same message also. I have tried to change my DB to utf-8, but it just won't work.  | 
                                                                                                    
                                                        | Thomas Johannessen
                                                                                                                             | Sunday 04 June 2006 10:29:18 am 
                                                                 
i got this problem first time a month before x-mas 2005, aprox.Now I have tried so many things, and the issues seems to be the php version, regarding the mySQL problem.
 I have also asked the EZ team about any solution, and the best they came up with, even when I asked how much they would charge to fix my setup, was that I should alter my db to utf-8, so it seams like a server related isse, that I cant solve. Now I am giving up this CMS, They have made it TOO specific for server-ware, so It cant be used on LAMP in general, but an ez special configured solution. They are in general a bit expencive for the low cost projects, but in range for the medium and up. But MY problem is that I do not want to pay a minimum 4000 NOK a year to be able to set up, test and maintain, develope on an EZ -- I had a EZ running on my own until the php was updated.  So long ez. It was fun.  www.taon.no
 
 | 
                                                                                                    
                                                        | Kristof Coomans
                                                                                                                             | Monday 05 June 2006 12:13:46 am 
                                                                 Hi Thomas What version of PHP/MySQL/Exponential are you using? independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org
                                                                 | 
                                                                                                    
                                                        | Matt Brady
                                                                                                                             | Sunday 30 July 2006 12:12:50 am 
                                                                 
Hi Kristof... if you're asking, I've got the same problem as Thomas. Using the install wizard it comes up the the error...
 --------------------
 Warning
 The database [crewmark_com_au_-_xportal] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set []. You will have to choose a database having support for [utf-8] or modify [crewmark_com_au_-_xportal] .
 --------------------
 My set up is:
 MySQL 4.1.20
 PHP4.4.2
 Exponential 3.8.3 (tried with 3.8.1 also)
 Database MySQL charset: UTF-8 Unicode (utf8)
 
I was running 3.8 on another server MySQL 4.1.19
 PHP4.4.2
 Exponential 3.8
 No problem on the previous.  Any ideas? It's not easy being easy.
                                                                 | 
                                                                                                    
                                                        | Guglielmo  Celata
                                                                                                                             | Wednesday 29 November 2006 7:07:55 am 
                                                                 
Hi everyone,I had similar problems, with different php and mysql versions.
 It seems that somehow this is a mysql issue.
 Once I removed all non-literal characters from the database name, the setup wizard accepted it and everything went smoothly.
 This was on a 3.8.6 version. 
cheers,Guglielmo
 | 
                                                                                                    
                                                        | stephen conklin, jr.
                                                                                                                             | Saturday 10 July 2010 9:43:57 am 
                                                                 This thread looks a bit outdated, but I found a simple fix to the problem. Log into your webserver's cPanel, go to PHP MyAdmin, select your database, then select "Operations" and then at the bottom, you'll see "Coalition" and a drop down menu where you can select utf-8 and "go". As soon as I did that, everything worked. |