Active Record Connect to MySQL 4.0 Database |
[eluser]kabbink[/eluser]
Hey guys, I am trying to make a remote Active Record connection to an older server running MySQL 4.0.26. The problem I am having is I keep getting the error Quote:Unable to set client connection character set: My connection info is as follows: Code: $db['npt']['hostname'] = "server.com"; I tried just not setting the char_set but then I also get a ton of errors. Any help would be appreciated as I don't think I am going to be able to upgrade the MySQL server. Thanks a lot for any ideas! Kevin
[eluser]ealonw[/eluser]
Try.......... latin1 latin1_general_ci Mysql 4.0 by default uses latin1.. From what im reading... You might want to create a test database to check this first...
[eluser]kabbink[/eluser]
I think the issue is that MySQL 4.0 doesnt use char_set in the same way. I found this which fixed the problem: http://codeigniter.com/wiki/MySQL_4.0/ Does anyone know if there is a way to apply that fix only when using a certain DB connection? My default connection works fine with the char_set variable. Thanks! Kevin |
Welcome Guest, Not a member yet? Register Sign In |