Re: Using COLLATE 'utf8_unicode_ci' for order clause in paginate?

I am also interested in finding how to COLLATE utf8 to a condition, please help?

On Friday, September 26, 2008 10:57:01 AM UTC-4, avairet wrote:

Hi,

Is it possible to add a collation clause in a order clause of
paginate() ?

I've tried those different solutions, but no success:

// tags_controller.php

public function admin_index() {
 $this->Tag->recursive = 0;
 $this->paginate = array('order' => 'name COLLATE 'utf8_unicode_ci'
ASC');
 $this->set('tags', $this->paginate());
}

public function admin_index() {
 $this->Tag->recursive = 0;
 $this->paginate = array('order' => 'name ASC',
'collate'=>'utf8_unicode_ci' );
 $this->set('tags', $this->paginate());
}

public function admin_index() {
 $this->Tag->recursive = 0;
 $this->paginate = array('order' => array('name'=> 'ASC'),
'collate'=>'utf8_unicode_ci' );
 $this->set('tags', $this->paginate());
}

Do you think I can do that with a custom paginate() method in my
model?

Thank's by advance for suggestions.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.