PHPackages                             sadapon2008/mysql\_collate - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. sadapon2008/mysql\_collate

ActiveCakephp-plugin[Database & ORM](/categories/database)

sadapon2008/mysql\_collate
==========================

Mysql Datasource For CakePHP supporting COLLATE in conditions

0.2(11y ago)113PHP

Since Feb 20Pushed 9y ago1 watchersCompare

[ Source](https://github.com/sadapon2008/mysql_collate)[ Packagist](https://packagist.org/packages/sadapon2008/mysql_collate)[ Docs](https://github.com/sadapon2008/mysql_collate)[ RSS](/packages/sadapon2008-mysql-collate/feed)WikiDiscussions master Synced 1w ago

READMEChangelog (2)Dependencies (1)Versions (3)Used By (0)

MysqlCollate
============

[](#mysqlcollate)

Mysql datasource for CakePHP 2.x supporting COLLATE in conditions.

Example
-------

[](#example)

### 1. change datasource in database.php

[](#1-change-datasource-in-databasephp)

```
public $default = array(
    'datasource' => 'MysqlCollate.Database/MysqlCollate',
    'persistent' => false,
    'host' => 'localhost',
    'port' => '',
    'login' => 'cakeBlog',
    'password' => 'c4k3-rUl3Z',
    'database' => 'cake_blog_tutorial',
    'schema' => '',
    'prefix' => '',
    'encoding' => 'utf8'
);
```

### 2. load MysqlCollateBehavior before Model::find()

[](#2-load-mysqlcollatebehavior-before-modelfind)

```
$options = array(
    'condition' = array(
        'Post.title LIKE' => 'aBcD',
    ),
    'order' => array(
        'Post.id' => 'ASC',
    ),
);

$this->Post->Behaviors->load(
    'MysqlCollate.MysqlCollate',
    array(
      'Post.title' => 'utf8_unicode_ci',
    )
);

$result = $this->Post->find('all', $options);

$this->Post->Behaviors->unload('MysqlCollate');
```

###  Health Score

24

—

LowBetter than 30% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity54

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~0 days

Total

2

Last Release

4197d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/2375761?v=4)[Tsuyoshi Sadakata](/maintainers/sadapon2008)[@sadapon2008](https://github.com/sadapon2008)

---

Top Contributors

[![sadapon2008](https://avatars.githubusercontent.com/u/2375761?v=4)](https://github.com/sadapon2008 "sadapon2008 (4 commits)")

---

Tags

cakephp

### Embed Badge

![Health badge](/badges/sadapon2008-mysql-collate/health.svg)

```
[![Health](https://phpackages.com/badges/sadapon2008-mysql-collate/health.svg)](https://phpackages.com/packages/sadapon2008-mysql-collate)
```

###  Alternatives

[helsingborg-stad/municipio

A bootstrap theme for creating municipality sites.

4028.6k10](/packages/helsingborg-stad-municipio)[andreyryabin/sprint.migration

bitrix migration module

206212.7k2](/packages/andreyryabin-sprintmigration)[pressbooks/pressbooks-book

This theme is named after Canadian media theorist Marshall McLuhan, who coined the phrase “the medium is the message.” It is designed for academic writing and is also suitable for fiction. Headings are set in Cormorant Garamond, and body type is set in Lora.

226.7k](/packages/pressbooks-pressbooks-book)[cpierce/cakephp-sybasedb

CakePHP plugin to handle PDO MSSQL Connections using dblib

1033.9k](/packages/cpierce-cakephp-sybasedb)[imsamurai/cakephp-serializable-behaviour

Behavior for saving and reading serialized data from/into database

137.7k3](/packages/imsamurai-cakephp-serializable-behaviour)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)