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 - 2005-05-19 : 17:09:59
|
Still having this issue, and was wondering if anyone has gotten a resolution to this. We do a lot of converting binary fields to string so that the user can see information. Some how with RS, it keeps giving weird square symbols. This however does not show in SQL Analyzer. Is there a way to remove this? |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-20 : 12:43:31
|
| Finallly got it to work. Didn't realize there were some unicode involved.CASE (UNICODE(CAST(CAST("BITS" AS VARBINARY(4000)) AS NVARCHAR(4000))) - ASCII(LEFT(CAST("BITS" AS VARBINARY(4000)), 1))) WHEN 0 THEN CAST(CAST("BITS" AS VARBINARY(8000)) AS NVARCHAR(4000)) ELSE CAST(CAST("BITS" AS VARBINARY(8000)) AS VARCHAR(8000)) END AS "BITS" |
 |
|
|
|
|
|
Weird symbols with binary?