I've got some data formatted in extended ASCII characters and the PHP is turning them into question marks. I am thinking if I force a utf8_encode on the data, this won't happen. Can someone help me understand how to incoporate utf_8 encode into the following:

$sp = mssql_init("sp_passwordencrypt"); // stored proc name
mssql_bind($sp, "@default_setting", ($extpassword), SQLVARCHAR, false, false,
255);
mssql_bind($sp, "@vl_password", ($extpassword), SQLVARCHAR, true, false,
255);
mssql_execute($sp);

I was thinking something like below but I am pretty sure this isn't right.
$sp = mssql_init("sp_passwordencrypt"); // stored proc name
mssql_bind($sp, "@default_setting", ut8_encode ($extpassword), SQLVARCHAR, false, false,
255);
mssql_bind($sp, "@vl_password", utf8_encode ($extpassword), SQLVARCHAR, true, false,
255);
mssql_execute($sp);

    Write a Reply...