Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2004-12-09 : 15:46:08
|
| I need help with this one. When I retrieve a binary field from reporting services, instead of getting spaces, I'm getting squares for all the empty spaces and weird symbols.Here's the select statement.Select Part_ID, Cast(Cast(Requirement_binary.bits as Binary(8000)) As Nvarchar(40)) as specsFROM Requirement_binaryHere's the Output:ÙÈ#8259;†š#17730;#17952;…Ò#18772;#18254;#11347;#18464;Ð#8261;#16706;#16978;ßë#18766; |
|
|
|
|
|
Binary shown with weird symbols