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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
