laravel/framework

binary() field in Schema Builder

aklinkert opened this issue · 10 comments

aklinkert commented

I hardly need to create a column of type binary$length) in MySQL but had to assert, that the $fluent->binary() method isn't building a BINARY but a BLOB field.

So what could be a possible sulution for this? Adding a new Fluent Method? In Laravel 3 I was easyly able to hack and dirty change the frameworks code to my needings, but with composer it luckily not possible.

Any ideas guys?

Cheers,
Bodo06

taylorotwell commented

Just do a DB::statement call and run the raw SQL you need to generate your column.

  • 👎34
fgambino commented

The only reason I can think of why this isn't implemented is that not all database types support the binary column. If that isn't the case, I would really like to see this added to Laravel.

spronkey commented

I'd definitely agree that this should be supported in some form, primarily for support for UUIDs.

  • 👍6
whoacowboy commented

+1 for adding binary support

  • 👍3
linux019 commented

I agree this is a bug, binary isn't the blob in mysql

  • 👍4
Petah commented

+1

  • 👍3
mpskovvang commented

It seems like you can just set the character set to binary as a workaround:

$table->char('url_hash', 16)->charset('binary');

This is actually shown as a real binary column type with a length of 16 in MySQL Workbench.

  • 👍16