Hi.
I have a database supported session with blob (binary) data. This data has been json objects before.
How can I read out this datatable. On a normal way
$sessionData = $this->find(‘all’)->toArray(); I’ll get a resource as data. And by reading like:
$query = $this->query(“SELECT CONVERT(data USING utf8) AS data FROM sessions LIMIT 0,1”);
$sessionData = $query->execute();
computer mysql get memory exhausted. but in phpmyadmin it works great. What is the best way o read this blob data and convert it in a json string/object??