PHPackages                             noud/laravel-schema-real-binary - 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. noud/laravel-schema-real-binary

ActiveLibrary[Database & ORM](/categories/database)

noud/laravel-schema-real-binary
===============================

Laravel case sensive Schema column type

v1.0.0(5y ago)06MITPHPPHP >=7.2.5

Since Sep 10Pushed 5y agoCompare

[ Source](https://github.com/noud/laravel-schema-real-binary)[ Packagist](https://packagist.org/packages/noud/laravel-schema-real-binary)[ RSS](/packages/noud-laravel-schema-real-binary/feed)WikiDiscussions master Synced today

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

[Laravel](http://laravel.com) [realBinary](http://github.com/noud/laravel-schema-real-binary), [case sensitive](http://en.wikipedia.org/wiki/Case_sensitivity) string, [Schema](http://laravel.com/docs/migrations#tables) [column](http://laravel.com/docs/8.x/migrations#columns) type
========================================================================================================================================================================================================================================================================================

[](#laravel-realbinary-case-sensitive-string-schema-column-type)

```
INSERT INTO `country` (`id`, `currency`) VALUES
('demo', 'eur'),
('be', 'EUR'),
('nl', 'EUR');

INSERT INTO `currency` (`code`, `symbol`, `format`) VALUES
('eur', '€', '{VALUE} {SYMBOL}'),
('EUR', '€', '{SYMBOL} {VALUE}'),
('USD', '$', '{SYMBOL} {VALUE}');
```

[Creating Columns](http://laravel.com/docs/migrations#creating-columns)
-----------------------------------------------------------------------

[](#creating-columns)

This Laravel package gives case sensative string fields with length and also as primary and foreign key by adding a real binary column to migrations.

### migrations

[](#migrations)

```
    Schema::create('currency', function (Blueprint $table) {
        $table->realBinary('code', 3)->unique();
        // works as well
        // $table->char('code', 3)->charset('binary')->unique();
        // more fields
    });

    Schema::create('country', function (Blueprint $table) {
        $table->string('id')->unique();
        $table->realBinary('currency', 3);
        // works as well
        // $table->char('currency', 3)->charset('binary');

        $table->foreign('currency')->references('code')->on('currency');
    });
```

### New Column Type

[](#new-column-type)

CommandDescription`$table->realBinary('fullname');`BINARY equivalent column with length 255`$table->realBinary('code', 3);`BINARY equivalent with a length### Available Column Type

[](#available-column-type)

CommandDescription`$table->char('code', 3);`
`$table->char('name', 100);`CHAR equivalent column with a length.used together with

ModifierDescription`->charset('binary');`Specify a character set for the column (MySQL)
make the column equivalent with BINARY.inspirations
------------

[](#inspirations)

This Laravel package is inspired by

- [Laravel Schema Builder : Creating a binary(16) column](http://stackoverflow.com/questions/49389233/laravel-schema-builder-creating-a-binary16-column)
- [Laravel Doctrine Extensions](http://github.com/laravel-doctrine/extensions)
    - [Doctrine Behavioral Extensions](http://github.com/Atlantic18/DoctrineExtensions)
    - [DoctrineExtensions](http://github.com/beberlei/DoctrineExtensions)
- [Extended Schema builder for Laravel 5](http://github.com/rafis/schema-extended)

###  Health Score

22

—

LowBetter than 22% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity49

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

Unknown

Total

1

Last Release

2067d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/4ec1447245e67e55f854cc51e58f1d36dd6cf9fcc79d5be90ffc8070b902fb4b?d=identicon)[noud](/maintainers/noud)

---

Top Contributors

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

---

Tags

laravellaravel-packagemysqlschemasql

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/noud-laravel-schema-real-binary/health.svg)

```
[![Health](https://phpackages.com/badges/noud-laravel-schema-real-binary/health.svg)](https://phpackages.com/packages/noud-laravel-schema-real-binary)
```

###  Alternatives

[owen-it/laravel-auditing

Audit changes of your Eloquent models in Laravel

3.4k33.0M95](/packages/owen-it-laravel-auditing)[staudenmeir/eloquent-json-relations

Laravel Eloquent relationships with JSON keys

1.1k5.8M24](/packages/staudenmeir-eloquent-json-relations)[bavix/laravel-wallet

It's easy to work with a virtual wallet.

1.3k1.1M11](/packages/bavix-laravel-wallet)[dragon-code/migrate-db

Easy data transfer from one database to another

15717.4k](/packages/dragon-code-migrate-db)[gearbox-solutions/eloquent-filemaker

A package for getting FileMaker records as Eloquent models in Laravel

6454.8k2](/packages/gearbox-solutions-eloquent-filemaker)[cybercog/laravel-ownership

Laravel Ownership simplify management of Eloquent model's owner.

9126.6k3](/packages/cybercog-laravel-ownership)

PHPackages © 2026

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