Re: error while quering from MSSQL server from a Linux box

Is the fields your querying a NVARCHAR, or anything that starts with N for that matter? If it is, change it to it's non-N equivalent, example: NVARCHAR(25) NAME To: VARCHAR(25) NAME On Sat, 2003-04-05 at 09:46, Dhaval wrote: > Hi All, > > I m trying to build a drop down dynamically. I m quering fields from MSSQL > 2000 Server. Now look wat is happning when i run my php from a Win2K PC and > from a Linux Box. > > Linux Machine > ABIDA PARVEEN > AHMED HUSSAIN MOHD.HUSSAIN > AHMED HUSSAIN,MOHAMMED HUSSAIN > ANWAR USSAI > ARVINDER SINGHOHAMMED HUSSA > ASHA BHOSLEGHOHAMMED > ASHA BHOSLE ,GHULAM ALIUSSAN > ASHA BHOSLE,GHULAM ALIUSSAN > ASHOK KHOSLAHULAM ALI > ASHOK KHOSLA,SUMITA CHAKRABORTY SAME > BEGUM AKHTAR UMITA CHAKRA > BHUPINDER SINGHITA CHAKRAORT > BHUPINDER SINGH, MITHALEE SINGHSAME > BHUPINDER SINGH,MITALEEE SINGHSAME > C.H. ATMASINGH,MI > C.H.ATMASINGH, > CHHAYA GANGULI,IALEEE SI > CHITRA SINGHI,IALEE > CHITRA SINGH,JAGJIT SINGHSIGHSAME > DILRAAJ KAURJAGJIT SING > > > Win 2K Server > > ABIDA PARVEEN > AHMED HUSSAIN MOHD.HUSSAIN > AHMED HUSSAIN,MOHAMMED HUSSAIN > ANWAR > ARVINDER SINGH > ASHA BHOSLE > ASHA BHOSLE ,GHULAM ALI > ASHA BHOSLE,GHULAM ALI > ASHOK KHOSLA > ASHOK KHOSLA,SUMITA CHAKRABORTY SAME > BEGUM AKHTAR > BHUPINDER SINGH > BHUPINDER SINGH, MITHALEE SINGH > BHUPINDER SINGH,MITALEE > C.H. ATMA > C.H.ATMA > CHHAYA GANGULI > CHITRA SINGH > CHITRA SINGH,JAGJIT SINGH > DILRAAJ KAUR > > > Values are getting cat after the original value. Can any one help in this. > I have tried using both sybase and mssql functions the results are the same. > > > > > Regards > Dhaval > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- Adam Voigt (adam@cryptocomm.com) Linux/Unix Network Administrator The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc