Re: Case Sensitive
From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 03/23/04
- Next message: Stefan Delmarco [MSFT]: "Re: Assertion: SQL Server 2000 can't issue a SOAP call"
- Previous message: Tibor Karaszi: "Re: Assertion: SQL Server 2000 can't issue a SOAP call"
- In reply to: Atley: "Case Sensitive"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 10:05:17 -0000
As Tenaya says, this is related to collations. It seems that your collation
on the publisher is case-sensitive and this has replicated to the subscriber
as a case-insensitive collation. Tenaya's query will allow a case-sensitive
comparison to be done on case-insensitive data. However, if you want the
column collation itself to be transferred to the subscriber, so queries
don't need to be modified, then have a look at the article properties,
snapshot tab - there is a checkbox to select the collation there. You'll
need to reinitialize for this to take effect. BTW, the database collation on
the subscriber is the one you're inheriting, so modifying this (ALTER
DATABASE...) and reinitializing would give the same result.
HTH,
Paul Ibison
- Next message: Stefan Delmarco [MSFT]: "Re: Assertion: SQL Server 2000 can't issue a SOAP call"
- Previous message: Tibor Karaszi: "Re: Assertion: SQL Server 2000 can't issue a SOAP call"
- In reply to: Atley: "Case Sensitive"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
