All Questions
Tagged with collation sql-server-2012
22 questions
5
votes
2
answers
2k
views
Case-Sensitive Collation on a select query in SQL Server
Our SQL Server's collation is set to SQL_Latin1_General_CP1_CI_AS
I have a requirement where we have the same values with different cases but SQL Server treats them the same since our collation is set ...
- 87
2
votes
1
answer
398
views
How to reverse only English words?
I've an nvarchar column with English and Hebrew letters in some fields.
In the fields where the English and Hebrew are together, the English letters are in reverse order (this is how the ERP program ...
- 71
2
votes
1
answer
2k
views
Implications of changing SQL Server collation
We are currently using SQL Server 2016 and currently the collation set on our database is SQL_Latin1_General_CP1_CI_AS. Our Analaysis services' collation is set to SQL_Latin1_General_CP1_CS_AS.
The ...
- 131
1
vote
1
answer
4k
views
Use LIKE in column with arabic [closed]
I have a SQL Server 2012 DB with a column that includes Arabic text. The column is nvarchar(MAX) with collation Arabic_CI_AI_KS_WS. To test if LIKE searches are working I copied some of the text ...
1
vote
2
answers
28k
views
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI"
We recently started getting the following error while executing a stored procedure:
System.Data.SqlClient.SqlException (0x80131904): **Cannot resolve the collation conflict between "...
5
votes
2
answers
25k
views
Why do I get incorrect characters when decoding a Base64 string to NVARCHAR in SQL Server?
I've been looking at how to decode Base64 with SQL Server and after searching around many solutions online (some from here) seem to be based upon this sort of method.
SELECT CAST(CAST('...
- 153
4
votes
2
answers
1k
views
Error while copying data over linked server
I am trying to copy the contents of 1 table from one database to another over a linked server.
I am using the following query to do so
insert into [Schema].[Table] select * from [Server].[Database]...
- 698
2
votes
0
answers
241
views
Linked servers not ignoring case after reboot
We have a SQL Server 2014 database with collation SQL_Latin1_General_CP1_CI_AS, which is case insensitive. It is linked to another SQL server database with the same collation. The second database ...
- 171
4
votes
2
answers
36k
views
SQL Server: Cannot resolve collation conflict between "Latin1_General_CI_AS" and "[garbage]"
So I'm writing a large UDF in T-SQL to be used in reporting. The UDF contains quite a few common table expressions.
At one point I was adding another CTE:
cteCmtCauses AS (
SELECT ProductId = p....
- 141
2
votes
1
answer
1k
views
Collation issue after update (KB3072779) of SQL Server 2012
If found the following error while starting my SQL Server 2012 instance, after the update KB3072779 performed by Windows Update (Windows Server 2012 Foundation).
Creating procedure ...
- 155
2
votes
1
answer
8k
views
Error 468 MS SQL Server : Couldn't resolve collation conflict between Arabic_CI_AI and Arabic_CI_AS when enumerating publications
When I try to expand the list of local publications under Replication element in SQ Server Management Studio, I get the following error :
Here is the detailed error log :
=============================...
- 659
7
votes
2
answers
12k
views
SQL Server: Is altering collation on existing databases safe?
I'm new to SQL Server, and wasn't aware of the possibility that T-SQL may be case insensitive.
I have been normalizing entities by splitting tables and constraints. I'm scared that if I change the ...
- 2,410
2
votes
0
answers
436
views
Import from dbf - collation
I select data from dbf files through OPENROWSET Visual FoxPro OLEDB.
Despite forcing collation on columns (e.g. SELECT name COLLATE Polish_CI_AS FROM Employees) the polish specific characters keep ...
- 303
11
votes
1
answer
11k
views
ORDER BY and comparison of mixed strings of letters and numbers
We need to do some reporting on values that are usually mixed strings of numbers and letters that need to be sorted 'naturally'. Things like, e.g. "P7B18" or "P12B3". @The strings will mostly be ...
- 9,698
6
votes
3
answers
8k
views
Contained DB Collation error
When changing a database to partially contained I am getting the following error:
Cannot resolve the collation conflict between "Latin1_General_CI_AS"
and "Latin1_General_100_CI_AS_KS_WS_SC" in ...
- 1,569
2
votes
1
answer
18k
views
How to disable case sensitivity in SQL Server 2012?
I tried to update collation_name in sys.databases. I am trying to change 'SQL_Latin1_General_CP1_CS_AS' to 'SQL_Latin1_General_CP1_CI_AS' in order to disable case sensitivity in table.
update d set d....
- 21
1
vote
0
answers
660
views
Speed up changing of collation?
I'm trying to change collation on all our databases, and doing it on one of the databases (~15gb) took me 42 minutes in testing even though I put it on SSD disc. Do anyone know any way to speed it up? ...
- 129
2
votes
3
answers
12k
views
Inserting Serbian Latin and Cyrillic characters
I am using SQL Server 2012 Express as part of my asp.net development workstation. Database and table collation is set to Latin1_General_CI_AI. Attribute types are nvarchar(max) and varchar(max).
...
- 155
13
votes
2
answers
10k
views
What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
During the installation of SQL Server 2012, in the Collation tab, i can choose between French_CI_AS and French_100_CI_AS.
What do they mean and which one is newer? When there's no Code, is it newer ...
- 405
7
votes
1
answer
5k
views
sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Can someone explain to me what is the difference between collation sql_slovak_cp1250_ci_as vs Slovak_CI_AS?
I have a db set to sql_slovak_cp1250_ci_as and shared hosting supports only Slovak_CI_AS. ...
- 244
5
votes
1
answer
9k
views
SQL Server: Collation of the resource database
I'm trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add those stopwords in the table sys.fulltext_stopwords.
When trying to get a list of stopwords and system-...
2
votes
2
answers
14k
views
SQL Server 2012 : how to add missing collation
When we run:
ALTER DATABASE abc COLLATE Latin1_General_CP1_CI_AS ;
GO
we receive:
Msg 448, Level 16, State 3, Line 1
Invalid collation 'Latin1_General_CP1_CI_AS'.
How can we add the missing ...
- 21