Support the ongoing development of Laravel.io →
posted 10 years ago
Database
Last updated 2 years ago.
0
Last updated 2 years ago.
0

hmm, i fairly confident that the issue is not php, mysql or my tables.

i am using phpmyadmin to access this db and i can select/update the BIT field using it without any problem

i am obviously missing something

Last updated 2 years ago.
0

Well that depends. We do not know what phpmyadmin is doing behind the scenes so it isn't safe to assume that just because it works in phpmyadmin it will work out of the box in php. Take a look at the answer provided on that stackoverflow page. Also http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html. All I am saying is that you should run that simple test first. Maybe it doesn't work but at least try every possible solution.

UPDATE: Here are some more references: http://stackoverflow.com/questions/8778906/fetching-bit-field-with-mysql-query, http://stackoverflow.com/questions/15106985/mysql-select-bit1-shows-as-string3

Last updated 2 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.