What is the difference between i, d, s, b in PDOStatement::bindParam

Question

PDOStatement::bindParam supports the following variables in prepared statements:

I know that if it i the value should be a number, if it s then it is a string, what are blob and double?

possible duplicate of [What is a Blob?](http://stackoverflow.com/questions/5414551/what-is-it-exactly-a-blob-in-a-dbms-context) — Gordon, Apr 14 '11 at 12:32
possible duplicate of [Difference between float and double](http://stackoverflow.com/questions/2160810/mysql-whats-the-difference-between-float-and-double) — Gordon, Apr 14 '11 at 12:34

score 1 · Accepted Answer · answered Apr 14 '11 at 12:22

1

"Double" is a float with double precision. "blob" is a "Binary Large OBject" (for example a file).

answered Apr 14 '11 at 12:22

KingCrunch

score 1 · Answer 2 · answered Apr 14 '11 at 12:24

integer :0 , -10, 20, 50 (ahem, a integer)

double :0.5, -20.5 (aka decimal number)

string :"some text","b" (but it is limited to aprox. 65k characters 255 character for mysql 5.0 and early)

blob :binary information, it is unlimited , it can be a string or a binary representation.

score 0 · Answer 3 · answered Apr 14 '11 at 12:25

I find questions like this irritating/lazy

It's all described in MySQL's manual:

An overview of all the different datatypes is given here: http://dev.mysql.com/doc/refman/5.0/en/data-types.html

3 Answers3