+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: utf8 and database connexion (/showthread.php?tid=8643)
utf8 and database connexion - El Forum - 05-25-2008
[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";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
utf8 and database connexion - El Forum - 05-25-2008
[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!
utf8 and database connexion - El Forum - 05-27-2008
[eluser]dede125a[/eluser]
It's ok, I've made an upgrade of database to mysql 5 and everything goes right
Thanks for your help !
utf8 and database connexion - El Forum - 05-27-2008
[eluser]Derek Allard[/eluser]
My pleasure. Enjoy your new setup
utf8 and database connexion - El Forum - 08-25-2008
[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
utf8 and database connexion - El Forum - 08-25-2008
[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.