> > > I use latest FPC from /trunk/ and this problem just started > happening recently. > > Pseudo code > > Write To SQL as Blob (using parameter binding) > > Param.AsString=uInt64Array.toBlob(MyList); > > unit "uInt64Array" > > procedure fromBlob(List,string) > count=length(string) div 8; // size of int64 > SetLength(List,count) > iPos:=1; > for iLcv=0 to Count-1 do begin > System.Move(String[iPos],List[iLcv],8); > Inc(iPos,8); > end; > end; > > function toBlob(List):string; > begin > iLen=System.Length(List)*8; > System.SetLength(Result,iLen); > iPos:=1; > for iLcv:=0 to High(List) do begin > System.Move(List[iLcv],Result[iPos],8); > Inc(iPos,8); > end; > end; > > Posting to the MySQL 5.1 database : the field size is as > expected. Retrieving /converting the list (asString) from the > database with all values set to small numbers appears to work > Retrieving converting the list (asString) from teh database > with larger values no longer works. > > Did anyone do anything to System.Move? > Did anyone recently do work on BLOB features to MySQL 5.1 > connector?
What is "large". Remember that the upper limit for blobs sent in a sql statement is max_allowed_packet. Default is 1M. http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_m ax_allowed_packet To send larger blobs you need to prepare the statement and send data in chuncks. Not supported in sqldb. Ludo _______________________________________________ fpc-devel maillist - fpc-devel@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-devel
