|
Home > Archive > MS SQL Server Tools > December 2005 > Strange Value in enterprise manager! nvarchar displays: <binary>
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Strange Value in enterprise manager! nvarchar displays: <binary>
|
|
|
| Hi All,
Im running Windows XP Sp2 and Sql Server 2000 Sp3a.
My problem is that if I have a field in a Table that is nvarchar or nchar
(Unicode)
the Enterprise Manager displays in the colums for this fields the text
"<binary>".
If I change the Datatybe to char (varchar) the real values are displayed.
We have many Pcs with the same setup but only mine shows this behaviour.
Hope you can help me...
Best regards
immes
| |
| Tibor Karaszi 2005-12-08, 7:24 am |
| My guess is that your PC doesn't have a font pack for the characters in the columns, hence EM show
it as "binary".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"immes" <immes@discussions.microsoft.com> wrote in message
news:54D5BE6B-56A3-4141-9A07- BEAC59ADEAC5@microso
ft.com...
> Hi All,
>
> Im running Windows XP Sp2 and Sql Server 2000 Sp3a.
>
> My problem is that if I have a field in a Table that is nvarchar or nchar
> (Unicode)
> the Enterprise Manager displays in the colums for this fields the text
> "<binary>".
>
> If I change the Datatybe to char (varchar) the real values are displayed.
>
> We have many Pcs with the same setup but only mine shows this behaviour.
>
>
> Hope you can help me...
>
>
> Best regards
>
> immes
|
|
|
|
|