Welcome Guest, Not a member yet? Register   Sign In
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.




Theme © iAndrew 2016 - Forum software by © MyBB