Laravel 4.2 BIT 数据类型问题

2022-01-08 00:00:00 bit mysql laravel-4

数据库表中有一个bit(1)类型的列.但它没有像我预期的那样工作.

there is a bit(1) type column in database table. but its not working as i expected.

问题是

$invitee = new Invitee();
$invitee->name = "name1";
$invitee->email = "example@mail.com";
$invitee->isActive = 0;    // "b'0'", '0', false,   are also not working
$invitee->save();

我需要在 isActive 列中放一个零 0 但每次我尝试添加记录时它的值 1一个 0.

I need to put a zero 0 in the isActive column but its getting value 1 every time when i try to add a record with a 0.

我在这里发现了一个问题..但答案并未描述问题的原因.很高兴有人能解释这个问题.

and i found a question in here.. but the answers are not describing the cause of the problem. glad if someone can explain the issue.

推荐答案

拥有 bit 类型字段意味着您在插入/更新该字段时需要使用原始值作为解决方法.

Having bit type field means that you need to use raw values as a workaround whenever you are inserting/updating that field.

这是因为 PDO 默认会绑定这些值,它们会被当作字符串处理,因此 bit 会产生 1:

That's because PDO by default will bind these values and they will be treated as strings, thus bit will result in 1:

DB::table('table')->insert(['bit_field' => 0]); // inserts 1
DB::table('table')->insert(['bit_field' => DB::raw(0)]); // inserts 0

如果可以的话,我建议将其更改为 tinyint.

And I suggest changing it to tinyint if you could.

相关文章