[eluser]quasiperfect[/eluser]
hi
i'm going nuts over a problem i'm having
i have a blob field that contains my session data
on local server (windows7 wamp64) when i run a select over the data from the blob field i get all contents in text format
something like this
Code:
mysql> select session_data from sessions;
+--------------------------------------+
| session_data |
+--------------------------------------+
| valoare_cod|i:2;txt_cod|s:5:"6 - 4"; |
+--------------------------------------+
1 row in set (0.00 sec)
on my live server (centos)i get something like this
Code:
mysql> SELECT session_data FROM sessions;
+------------------------------------------------------------------------------------------+
| session_data |
+------------------------------------------------------------------------------------------+
| SgMM1StVLITU6V_kszNHLVlkZmB2a82Ktzz2XB7XZgtnMAQAcJw4ItZnSqy7V-f3Wf9AdH9ZRelOmJpTkWr6Yg.. |
+------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
what i'm doing wrong here ? any idea what the problem could be ?
update
i forgot to mention the application works correctly on both servers my problem is when i try to do a select on the blob
Code:
SELECT session_data FROM sessions where session_data like '%sometexthere%'
on local server i get the results, on live server i get 0 results