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-14 : 12:41:00
|
| One of my query has a convert binary to a Varchar. When there are blank spaces, it appears as squares. When I ran this in the query analyzer for SQL, it seems to appear fine. Is this some kind of bug with Reporting Services in that it inserts symbols when there's blank spaces?CAST(CAST(REQUEST.BITS AS BINARY(8000)) AS VARCHAR(40)) AS DETAILThat's the query for converting the binary, not sure why it's like that for Reporting Services. Any ideas? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-14 : 13:18:02
|
| I'll bet you the bits you're converting are actually Unicode. Try converting it to nvarchar and see if that fixes it. |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2004-12-14 : 16:28:45
|
| Thanks for replying. I converted it to nvarchar and it seems to get worse. Now there are more squares and it inserts like percent signs. WIth just the varchar, it will only display squares after the data. It will only do this in reporting services. When I run this off query analyzer or the query pane, it doesn't do it. Only when I go to preview to view the report that I have created is when I get the squares. |
|
|
|
|
|
|
Extra blank spaces have square symbols?