RE: SQL Server 2005 DB Collation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't know about code page 437. But we typically use the setup default,
which for the US English system locale is:

the SQL Server collation: Dictionary order, case-insensitive, for use with
1252 character set.

This has worked fine for us. I'd try very hard to avoid any obscure
collation as that can create a lot of grief.

Linchi

"RG" wrote:

I have a db whose collation is SQL_Latin1_General_CP437_CL_AL.

I am running vb application which write encrypted data this db via ODBC
connection. It would appear that I am encountering when writing characters
of ASCII value > 128. I am assuming that SQL_Latin1_General_CP437_CL_AL
has only 128 characters. If so, what collation should I use to store ASCII
values > 128?

Thanks in advance

.

Relevant Pages

  • Re: PATINDEX
    ... stored (binary representation), and how characters are sorted (Sort Order). ... In some cases the collation the binary representation and sort order might ...
    (microsoft.public.sqlserver.programming)
  • Re: PATINDEX
    ... The range is not based on the binary representation of characters. ... declare @cedilla char ... Under the collation and code page defaults for a standard Windows and ...
    (microsoft.public.sqlserver.programming)
  • Re: Update Column with Restricted Collation?
    ... replace the varchar value with a value with a "restricted collation" ... like ASCII 7-bit so characters not on a standard US keyboard will be ... DECLARE @result VARCHAR= ''; ... If you are limiting the range of characters to ASCII because you are going to use the strings as machine-readable data, you may want to consider using Latin1_General_BIN2 for the column's collation. ...
    (microsoft.public.sqlserver.programming)
  • Re: Default charset in sqlserver 2000? / jtds
    ... > The columns share this collation. ... points are control characters to 8859-1. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • RE: Collation Sequences, Accented Characters and ORDER BY clauses
    ... In SQL's accent sensitive collations, the presence or absence of accented ... So, for example, all a's are expected to sort ... Collation Sequences, Accented Characters and ORDER BY clauses ...
    (microsoft.public.sqlserver.odbc)