$query ='select Address collate Chinese_PRC_CI_AS from A';
$rs = mssql_query($query,$conn) or die ('Query failed: '.$query);
if ($row = mssql_fetch_array($rs)) {
$address= $row[0];
$address= iconv('GBK','UTF-8',$address);
echo $address; }
$tit_query ="SELECT convert(varchar,PhotoAlbumName collate Chinese_PRC_CI_AS) as PhotoAlbumName,PhotoAlbumSID FROM tblPhotoAlbum where PhotoAlbumID = 'B8-B1-55-2A-01-BD-F1-A6-C1-EF-EF-52-76-42-54-3C'";