#6396: MySQL support bit field in querys
-----------------------------+----------------------------------------------
Reporter: mohsentaheri | Type: Enhancement
Status: new | Priority: Medium
Milestone: 1.2.x.x | Component: Model
Version: 1.2 Final | Severity: Normal
Keywords: bit column | Php_version: n/a
Cake_version: |
-----------------------------+----------------------------------------------
if we have bit array field in mysql cakephp act as text field,[[BR]]
as you know when you want to add bit array field you must add extra b
before value,[[BR]]
this is my solution in dbo_mysql.php[[BR]]
in '''function column''' add extra '''if''':[[BR]]
{{{
if (strpos($col, 'bit') !== false) {
return 'bit';
}
}}}
[[BR]]
and in '''function value''' add extra '''case''':[[BR]]
{{{
case 'bit':
$data = "b'" . mysql_real_escape_string($data, $this->connection) . "'";
break;
}}}
I wish this is useful for someone.
--
Ticket URL: <https://trac.cakephp.org/ticket/6396>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to tickets-cakephp@googlegroups.com
To unsubscribe from this group, send email to
tickets-cakephp+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
