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 1mo 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 32% 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

4100d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/65dc9be5db0d82d13f7e7578d6e28a7768eb0b4dad1d812716e9441af5dd78db?d=identicon)[sadapon2008](/maintainers/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

[josegonzalez/cakephp-upload

CakePHP plugin to handle file uploading sans ridiculous automagic

5451.3M9](/packages/josegonzalez-cakephp-upload)[muffin/trash

Adds soft delete support to CakePHP ORM tables.

851.3M11](/packages/muffin-trash)[admad/cakephp-sequence

Sequence plugin for CakePHP to maintain ordered list of records

46489.9k6](/packages/admad-cakephp-sequence)[cpierce/cakephp-sybasedb

CakePHP plugin to handle PDO MSSQL Connections using dblib

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

Behavior for saving and reading serialized data from/into database

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

PHPackages © 2026

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