• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
utf8 and database connexion

#1
[eluser]dede125a[/eluser]
I am moving an "old" application made on CI 1.5.4 to 1.6.2 everything goes right on my Mac (with MAMP) but once I test my application on the real server I've got this error :
"Unable to set client connection character set: utf8"

I saw that these 2 lines :
Code:
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
appears in the 1.6.x database config file.

Naively, I tried to comment theses 2 lines but the DB driver gave me 4 new error !

I think it's because my local database is version 5.0.37 and the real server is on 4.0.25 but I'm not a db specialist so...

Like you see, I'm lost :down:

Thanks for your help

#2
[eluser]Derek Allard[/eluser]
Anychance you can get your version of mysql updated?

Server Requirements
Quote:Current supported databases are MySQL (4.1+)...

That's the best solution, but in the meantime http://codeigniter.com/wiki/MySQL_4.0/

Welcome to CodeIgniter!

#3
[eluser]dede125a[/eluser]
It's ok, I've made an upgrade of database to mysql 5 and everything goes right Smile

Thanks for your help !

#4
[eluser]Derek Allard[/eluser]
My pleasure. Enjoy your new setup Wink

#5
[eluser]Unknown[/eluser]
i am facing same problem at my 3rd party server
i can not upgrade my mysql
so what i do please help?
mysql vesrion is
MySQL - 4.0.27

CI version.
Version 1.6.4

#6
[eluser]Derek Allard[/eluser]
[quote author="Derek Allard" date="1211769991"]but in the meantime http://codeigniter.com/wiki/MySQL_4.0/[/quote]

Welcome to CI.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.