php.activerecord

I've added a wiki entry to show how to do this http://www.phpactiverecord.xyz/projects/main/wiki/Configuration__Setup#encoding

Hi guys.

Your solution don't work for me.

I added a line in the Connection class __contruct

$this->connection->query("SET NAMES 'utf8';");

It's working fine now.

Thanks anyway

You're probably not using the most recent version then. You'll need the latest for it to work.

Tanks.

Hi'ya'all

i think that should add validation for mysql also;
active-records\lib\connection.php (line 203)
...
if($info->protocol=='mysql') {
$this->connection->query("SET NAMES 'utf8';");
$this->connection->query("SET CHARACTER SET utf8;");
}

Thank u very much

no problem - i have found another problems so i extend little

if($info->protocol=='mysql')
                       {
                            $this->connection->query("SET NAMES 'utf8'");
                            $this->connection->query("SET CHARACTER SET utf8");
                            $this->connection->query("SET character_set_connection=utf8");
                            $this->connection->query("SET character_set_client=utf8");
                        }

I don't work.Please help me !

view uf8 is ok !
But insert to database not work

Check your mysql what is the column charsets and also check if you sending to mysql as default utf-8

My database

CREATE TABLE `users` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`gid` int(11) DEFAULT NULL,
`username` text,
`password` text,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8

Can you give me your application for a test !

Thank you !

First, i think you should read http://www.phpactiverecord.xyz/projects/main/wiki/Conventions
uid = should be id
gid = group_id
users = people

2nd, ALTER TABLE `users` CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;

not work

`username` text CHARACTER SET utf8,
  `password` text CHARACTER SET utf8,
Code
$user = new Users;
$user->username="Cộng hòa xã hội chủ nghĩa việt nam";
$user->password='123456';
$user->save();

view database "C?ng h?a x? h?i ch? ngh?a vi?t nam"
Can You help me ? You can send me your test to email: [email protected]
You can remote my desktop with teamviewer!
ID:868 417 770
Pass:6151

Thank you very much !

Thanh you !
I have done !

I update activerecord 1.0rc1

December 26, 2011
The wiki's entry by Kien La does not work to me.

Solution: Change '?' delimiter to ';'.

Example:

$config->set_connections(array(
 'development' => 'mysql://user:pass@localhost/mydb;charset=utf8')
);

Now, it works fine!

ref.: PHP ActiveRecord Version 1.0 - June 27, 2010

Sergio M C Figueiredo
http://blog.devdelver.com

I recently had the same problem. I updated the phpactiverecord version from stable to nightly build (php-activerecord-20120801). On my local environment i use ubuntu server 12.04 (php version 5.3.10, mysql 5.5.24, apache2) and had no problems with utf8 content. but when i published on a red hat server, it failed to show utf8 content.

my connection configuration was:

'production' => 'mysql://user:[email protected]/mydatabase;charset=utf8;');

i then read the forum, tried several things an the found the solution to change the configuration to this:

'production' => 'mysql://user:[email protected]/mydatabase?charset=utf8');

now it works on both systems. Hope this helps you guys.

Claus

Here is an ORM that works with MySQL
https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx