Re: change column type

[Simon Oliver]

Let's see an example of your code, your SQL and your data, but...

as I don't know if your using bind parameters or not - if not then you might
want to use the quote method, specifying a data type:

$sql = $dbh->quote($value, SQL_VARCHAR);

If you are binding then use something like this:

$sth->bind_param(1, $value, { TYPE => SQL_VARCHAR});

--
  Simon Oliver