BIT datat type rendering issue in laravel

Question

I have a bit type column in database table. First I was having problem saving field which solved by this question Laravel 4.2 BIT datatype issue

But now when I retrieve data i a getting that bit type field as {}.

"active": {}

Please help me if anyone has solution.

Edit: Sorry, the problem is while creating object.

I have a "schedule" table in which I have "active" field which is BIT. When I create new Schedule using laravel eloquent, returned object has 'active' field as emptystring {}, No matter bit value is 0 or 1.

$schedule = Schedule::create($input);

returns

{
      "active": {},
      "cityId": 84,
      "eventdate": "2015-09-01T00:00:00+05:30",
      "updatedon": "2015-09-15 16:53:48",
      "createdon": "2015-09-15 16:53:48"
}

in that question it self suggested change bit to tinyint right? — RaMeSh
– RaMeSh, Commented Sep 15, 2015 at 10:37
And show me your query also,we can easily understand your problem — RaMeSh
– RaMeSh, Commented Sep 15, 2015 at 10:38
change to bit to tinyint is right but i can't change database definition. — sp11
– sp11, Commented Sep 15, 2015 at 10:58

RaMeSh · Accepted Answer · 2015-09-15 10:45:54Z

0

I have faced same problem, i have done like this.

Normally i have retrieve like this but failed to get the email data.In this case email datatype is BIT.

$query = "SELECT Username, email FROM users";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
print_r($row);

after that i have tried like this and it's working fine for me.

$query = "SELECT Username, CAST(email AS unsigned integer) AS emailid FROM users";

answered Sep 15, 2015 at 10:45

RaMeSh

3,4642 gold badges21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BIT datat type rendering issue in laravel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related