inserting a string variable

[Steve Spence]

I'm trying to insert a string (5 byte hex) into the database.

I've tried:


String stringOne = "2d144bf28";

sprintf(buf, "INSERT INTO database.table VALUES (%s)", stringOne);

and

char* stringOne[ ] = {"2d144bf28"};

sprintf(buf, "INSERT INTO database.table VALUES (%s)", stringOne[0]);

Neither works.

First one hangs the sketch, second example gives "Error: 51 = Unknown column '2d144bf28' in 'field list'."

however;

int stringOne = 1234;

sprintf(buf, "INSERT INTO database.table VALUES (%i)", stringOne);

works fine.