"immes" <im***@discussions.microsoft.com> wrote in message
news:54D5BE6B-56A3-4141-9A07-BEAC59ADEAC5@microsoft.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

"Tibor Karaszi" wrote:

> 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" <im***@discussions.microsoft.com> wrote in message
> news:54D5BE6B-56A3-4141-9A07-BEAC59ADEAC5@microsoft.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
>
>

"immes" <im***@discussions.microsoft.com> wrote in message
news:43DCA48B-50CD-4994-A9B2-8123872C2F85@microsoft.com...
> Hi Tibor,
>
> thanks for the answer. Which font pack do I need?
> Why does this happen only on my Computer?
>
>
> "Tibor Karaszi" wrote:
>
>> 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" <im***@discussions.microsoft.com> wrote in message
>> news:54D5BE6B-56A3-4141-9A07-BEAC59ADEAC5@microsoft.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
>>
>>

"Tibor Karaszi" wrote:

> > Which font pack do I need?
>
> I don't know, I'm not a Windows technician. If my guess is on target, you first need someone to look
> at what is in the columns to determine what language (character sets) and then install that on your
> machine.
>
>
> > Why does this happen only on my Computer?
>
> Again, if my guess is right: Because the other has the font packs installed but your machine
> doesn't.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "immes" <im***@discussions.microsoft.com> wrote in message
> news:43DCA48B-50CD-4994-A9B2-8123872C2F85@microsoft.com...
> > Hi Tibor,
> >
> > thanks for the answer. Which font pack do I need?
> > Why does this happen only on my Computer?
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> 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" <im***@discussions.microsoft.com> wrote in message
> >> news:54D5BE6B-56A3-4141-9A07-BEAC59ADEAC5@microsoft.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
> >>
> >>
>
>

"immes" wrote:

> Hi
>
> I'm from Germany, so the columns contain "normal"  characters (abcdef...).
> Nothing you really need unicode for.
> My OS and also the Sql Server is in German language.
>
>
> "Tibor Karaszi" wrote:
>
> > > Which font pack do I need?
> >
> > I don't know, I'm not a Windows technician. If my guess is on target, you first need someone to look
> > at what is in the columns to determine what language (character sets) and then install that on your
> > machine.
> >
> >
> > > Why does this happen only on my Computer?
> >
> > Again, if my guess is right: Because the other has the font packs installed but your machine
> > doesn't.
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> > Blog: http://solidqualitylearning.com/blogs/tibor/
> >
> >
> > "immes" <im***@discussions.microsoft.com> wrote in message
> > news:43DCA48B-50CD-4994-A9B2-8123872C2F85@microsoft.com...
> > > Hi Tibor,
> > >
> > > thanks for the answer. Which font pack do I need?
> > > Why does this happen only on my Computer?
> > >
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > >> 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" <im***@discussions.microsoft.com> wrote in message
> > >> news:54D5BE6B-56A3-4141-9A07-BEAC59ADEAC5@microsoft.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
> > >>
> > >>
> >
> >