Re: set up sql server 2000 - Collation settings

Tech-Archive recommends: Fix windows errors by optimizing your registry

lenny_at_mail.hongkong.com
Date: 01/28/05


Date: 27 Jan 2005 18:30:49 -0800

I ran into similar problem. I cannot find the CP 936 that was chosen in
sql server 7 when i try to setup sql server 2000. now i end up with
chinese characters that display as "???". :(
Even if I have chinese fonts installed in the OS, and chose Chinese PRC
as the collation during sql server 2000 install, and specified a
chinese font in the results text displayed for query analyzer, that
didn't solve the problem when i restore the database file in use from
sql server 7 into 2000.



Relevant Pages

  • Re: Strange Recordset/Query Problem
    ... > display in SQL Server. ... table names for each field in the SELECT clause, ON clauses, and WHERE ... Also, SQL Server is not case sensitive, so you can save your eyes by using ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)
  • Strange Recordset/Query Problem
    ... Access 2000 database to a SQL Server 2000 database. ... display in SQL Server. ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)
  • Re: Text below an image
    ... > sql server db underneath the image. ... > So you have a picture and underneath its dimensions. ... load it from there into the image class. ... >> Im gonna display a list of images in an aspx page from sql server Db.Each ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FTS query performance on SQL 2005
    ... Basically what i do is bank on the fact that it is rare for most people to ... believe this is because the full resultset is returned from the FTE back ... SQL Server, and then the count is taken on that. ... but I'd like to also display "Showing results ...
    (microsoft.public.sqlserver.fulltext)
  • MSHFlexgrid not displaying data from ADO data control
    ... if I put it onto a clients machine none of the ... MSHflexgrids display any data. ... The MSHflexgrids data sources are ADO data controls which are ... The SQL Server uses windows network authentication to allow access and I ...
    (microsoft.public.vb.general.discussion)