All Questions
Tagged with collation sql-server-2008-r2
16 questions
1
vote
2
answers
254
views
Replace function removing Ones / 1 when removing char(185) (superscript 1)
Ok as the title suggests this is occuring.
When using the REPLACE function on char(185) for data in a temporary table, ones ("1") are being removed as well.
SQL SERVER 2008R2
UNICODE Data
DB ...
- 349
3
votes
2
answers
194
views
Making collations uniform across multiple SQL Server 2008 databases [closed]
I have been assigned to try and make collations uniform across databases. Currently, it's a mess, different collations everywhere.
This is mostly solved by using collate database default in queries ...
2
votes
1
answer
243
views
SQL Server 2008R2 database migration to cloud: case-insensitive collation changed to case-sensitive
Recently felt the fall out (crappy legacy code base) of a database migration by a third party vendor where the collation was swapped from case-insensitive to case-sensitive. I am wondering if the ...
- 133
20
votes
2
answers
5k
views
Can't update "CO2" to "CO₂" in table row
Given this table:
CREATE TABLE test (
id INT NOT NULL,
description NVARCHAR(100) COLLATE Modern_Spanish_CI_AS NOT NULL
);
INSERT INTO test (id, description) VALUES (1, 'CO2');
I've realised ...
- 1,079
9
votes
3
answers
2k
views
Trigger to change Database collation on creation
I'm trying to create a Trigger, to alter collation of a database on its creation, but how can I catch the database name to use inside the trigger?
USE master
GO
CREATE TRIGGER ...
- 7,484
1
vote
2
answers
335
views
Can a table column be written to treat two different values as the same value?
The title is a bit generic, but the specific issue is that the United Kingdom of Great Britain and Northern Ireland has two commonly used 2-character codes. ISO 3166-1 specifies the code GB as the ...
- 119
2
votes
1
answer
576
views
Having Sharepoint on a different Collation than the system Databases?
After installing Sharepoint I realized that the collation of all Sharepoint databases is Latin1_General_CI_AS_KS_WS while my server collation is Latin1_General_CI_AS. From official documentation I see ...
- 1,373
20
votes
2
answers
43k
views
Latin1_General_BIN performance impact when changing the database default collation
I have set the database collation to Latin1_General_BIN, to make string comparisons case-sensitive. Will this have an impact on performance? Will it have any impact on DML or DDL operations in the ...
- 303
1
vote
0
answers
107
views
SQL Server 2008 R2 SP2 Execution Plan not getting missing index suggestions
I have several SQL Server 2008 R2 SP2 that have server collation Latin1_General_BIN. These instances will not give me the missing index suggestion with performing an execution plan. I have other ...
- 11
7
votes
2
answers
7k
views
Cannot remove char 0x0000 from NVARCHAR column
So, I know all about the Replace function and a bug with char(0).
I have a column (NVARCHAR(128)) that has some NCHAR(0x0000) characters from a bad import.
I'm using SQL Server 2008 R2.
The ...
- 289
3
votes
2
answers
5k
views
Using collate: When to use and when not to use
In one of my applications we had tsql like shown below
SELECT DISTINCT [Dblist].[DbName] AS [DbName]
FROM [Common].dbo.[Dblist]
WHERE dbname not in (
SELECT [name]
FROM master.dbo....
- 3,131
2
votes
0
answers
605
views
Avoiding Functions() in the Where clause
Okay, while analyzing queries against a SQL Server 2008 R2 database, I happened upon the following query:
(@p__linq__0 nvarchar(4000))
SELECT TOP (1) [Extent1].[OrderSOId] AS [OrderSOId], [Extent1]
...
- 187
-1
votes
1
answer
471
views
Does changing the collation of a column change TIMESTAMP (rowversion) values?
I need to run
ALTER TABLE ...
ALTER COLUMN ... COLLATE Czech_CI_AS ...
for multiple columns in a database. All those tables have TIMESTAMP column which is used for database synchronization.
Will ...
- 629
0
votes
1
answer
1k
views
Server default collation change or not change
The default collation of our new server is SQL_Latin1_General_CP1_CI_AS. However the collation of the other databases which are used as the source to migrate data into the target databases on this ...
- 3,694
5
votes
2
answers
8k
views
Why not use SQL_Latin1_General_CI_AS for a global system?
What would be some really good reasons to not use the SQL_Latin1_General_CI_AS collation on a system which handles English, German, Japanese, and Chinese data?
I'm having a really hard time finding ...
- 203
3
votes
2
answers
4k
views
Multiple charsets and Collations for a Multinational Database
After decades of business speaking with companies that adhere to the general Latin1 Collation, my company is facing the issue of storing information in a different charset and collation: Greek.
So, it'...
- 133