php - How do I get the complete string of a BLOB using PDO? -



php - How do I get the complete string of a BLOB using PDO? -

i'm creating c# php info connector allow standardized connection web server host info database c# winform application. working 1 little exception.

the basic of utilize this.

c# sends aes encrypted command server. server parses command , performs sql query , returns aes encrypted string. string converted datatable in c#.

when sql contains column blob i'm getting little part of total data. seems field beingness limited first 2792 bytes.

is there setting preventing total contents of blob returned?

i'm not sure if helpful, here code work.

$dataconnection = new pdo('mysql:host=10.10.100.102;dbname=jmadata', "root", "nbtis01"); $dataconnection->setattribute(pdo::attr_errmode, pdo::errmode_exception); if (isset($parameters['sqlquery'])) { // default list $sqlquery = $parameters['sqlquery']; unset($parameters['sqlquery']); } if (isset($parameters['limitoverride'])) { if (!strpos(strtoupper($sqlquery), "limit")) $sqlquery = rtrim($sqlquery, ';') . " limit " . $parameters['limitoverride']; unset($parameters['limitoverride']); } $queryparams = array(); foreach ($parameters $key => $value) if ($key !== '') $queryparams[$key] = $value; $query = $dataconnection->prepare($sqlquery); $query->execute($queryparams); $returnarray = $query->fetchall(pdo::fetch_assoc); if (!$returnarray) $returnarray[0] = array("noresults" => "");

edit -- answer

i found issue. problem had nil pdo, php or mysql. taking blob info , doing base64 before putting in array, split characters using build result string converted datatable in c# used non-printable characters , binary info string might have included these characters. issue when doing convert in c# original string convert byte array. using system.text.encoding.ascii.getstring convert base64 byte array original string. working on binary info blob fields.

the suggestion might terminating character made me find it. 1 time base64 converted string using ascii there turning terminator , stopping convert @ point. 1 time found changed system.text.encoding.default.getstring , works perfect.

posted reply in case else might trying , having same issue.

more details in edit of question.

changed system.text.encoding.ascii.getstring system.text.encoding.default.getstring , issue resolved.

thank crunch pointing me in right direction find solution.

php sql pdo

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more