I'm currently querying a MS SQL Server database through PHP and sqlsrv_connect protocol. In my table, there is a column with file locations:
I'm then utilizing PHP's str_replace() to convert this to a URL:
$imglink = str_replace('\\FILESERVER123\IDImages\Photos','http://webserver/idphotos/',$row['SeeExampleAbove'])
The "003" is being converted into what looks like a superscript "L" at some point. It appears to be happening in the initial query and not during the str_replace(), but I'm at a loss as to why and my Google skills aren't helping this time.
Is it something to do with character encoding?
Thanks for any help someone can offer! -Allen