Re: Using a calculation in Order By

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JKramer (JKramer_at_discussions.microsoft.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 10:19:02 -0800

Thanks for the quick reply!
Product: SQL Server Standard Edition
OS: Windows 2000 Server (SP4)

Results from EXEC sp_helpsort:
Server default collation
                                                       
------------------------------------------------------------------------------------------------
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page
1252 for non-Unicode Data

"Anith Sen" wrote:

> Can you post you SQL Server version & the result of: EXEC sp_helpsort ?
>
> --
> Anith
>
>
>

Relevant Pages

  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ... The destination columns are nvarchar and store unicode data correctly. ... Configuration: MS SQL server 2005 SP2, and MS jdbc driver version: 1.1 ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
    ... > data on an MS SQL Server 2000 containing Unicode data in NVARCHAR ... > DBD::ODBC returns all latin characters, ... > DBD::ODBC sources for any hints, ...
    (perl.dbi.users)
  • Re: Mail Merge using SQL Server 2005
    ... The problem is that Word 2000 can only se ODBC to connect to SQL Server, ... ODBC does not pass the Unicode data in your NVARCHAR fields along. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: PHP and Unicode
    ... The SQl Server database will store Unicode data (Chinese, ... PHP will be used to parse the data to the HTML web page. ...
    (comp.lang.php)
  • PHP and Unicode
    ... I'm building a website that will use Unicode data. ... The SQl Server database will store Unicode data (Chinese, ... PHP will be used to parse the data to the HTML web page. ...
    (comp.lang.php)