Stack Overflow
Stack Overflow

Questions tagged [sql-server-collation]

18 questions
6
votes
4 answers

SQL Server turkish character situation

I am having a Turkish Character problem in ASP.NET and SQL Server. I have searchbox in asp.net and trying to do a search in database. However, I am having problems in Turkish characters. When I search for "GALVANİZ" which contains illegal "İ"…
Arif YILMAZ
  • 5,754
  • 26
  • 104
  • 189
2
votes
1 answer

How to set collation for MS SQL Server using Testcontainers

Using Testcontainers, how can I set the database collation when starting a docker image for a MS SQL Server database?
JeanValjean
  • 17,172
  • 23
  • 113
  • 157
1
vote
0 answers

What is the best collation which allows to consider equal German umlaut characters like 'UE'='Ü', 'AE'='Ä, 'ß'='ss'?

As title, I am looking for the best collation which allows to consider equal German characters like 'UE'='Ü', 'AE'='Ä, 'ß'='ss', etc.
fededim
  • 429
  • 5
  • 12
1
vote
0 answers

Querying different collations across linked servers - works one direction, not the other

I'm trying to query between 2 servers with different collations. One query works, the other doesn't. I want to know why. ServerA is 2019 RTM using Latin1_General_BIN collation. ServerB is 2016 SP1 using SQL_Latin1_General_CP1_CI_AS collation. The…
mezzanayne
  • 11
  • 2
1
vote
1 answer

SQL Server Unicode character replacement

I'm trying to remove/replace certain unicode symbol characters from text in SQL Server 2019. The server/DB I'm working with has collation Latin1_General_CI_AS. I can't change the collation of the server/DB so i tried this (and most of the time it…
Geo
  • 13
  • 2
1
vote
2 answers

How to retrieve German characters from a large CSV File into SQL Server 2017 script

I have a CSV file including a list of employees, where some of them includes German characters like 'ö' in their names. I need to create a temp table in my SQL Server 2017 script and fill it with the content of the CSV file. My script is: CREATE…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
1
vote
2 answers

Replace of NCHAR(1600) is not working on SQL Server

When I run bellow code the NCHAR(1600) is not replaced SELECT REPLACE(N'foo' + NCHAR(1600), NCHAR(1600), '**') --> output: fooـ My database collation is Persian_100_CI_AI The default collation of SQL server is Persian_100_CI_AI too My SQL server…
Fred
  • 3,365
  • 4
  • 36
  • 57
0
votes
1 answer

The Collation specified by SQL Server is not supported in c sharp

I am currently using C sharp .net 6 and connecting to a database using System.Data.SqlClient. When it attempts to read from a table, it returns the error: The Collation specified by SQL Server is not supported. private const string SQLUSERS=…
avdeveloper
  • 449
  • 6
  • 30
0
votes
1 answer

Specify Collation in Docker installation

I've used this guide to install sqlserver on docker. However, the default collation it sets up is not the one I require. Is there a way to specify the desired collation during the installation process without having to change it afterwards?…
Yan Ayata
  • 3
  • 1
0
votes
0 answers

Inserting a ≤ character gets converted into = sign

We have a SQL server running on Azure RDS, We have a problem where a stored procedure is doing some ETL work parsing JSON value, ultimately I tracked down the problem to this minimal reproducible scenario: CREATE TABLE [dbo].[conditions_test] ( …
Carmageddon
  • 2,627
  • 4
  • 36
  • 56
0
votes
1 answer

How to convert latin1_swedish_ci collation string into hindi text

Hi Everyone i am facing a problem with string collation change as i have millions of rows in latin1_swedish_ci collation and i wants to convert the reocords to hindi text and store in utf8_unicode_ci $string="अपने पà¥à¤¯à¤¾à¤° से…
Ajay Chauhan
  • 1
0
votes
0 answers

Change SQL Server 2017 collation back

If we wanted to put back the collation for our SQL instance (server collation, not individual database) could we just restore backups of master and MSDB from when the old collation setting was in effect?
justin setliffe
  • 1
  • 3
0
votes
1 answer

How to change collation on SQL Server by SSMS

The purpose is that I want to change collation (database, table, column) from Chinese_Taiwan_Stroke_CS_AS to SQL_Latin1_General_CP1_CI_AS. There is the way that I change the collation on database. First, I use the old_db tasks --> General scripts...…
KENNY CHEN
  • 1
  • 2
0
votes
1 answer

Bug with transactional replication when databases are not in same collation

We have set up Transactional Replication in which Publisher and Subscriber side databases are put under the same SQL Servers. Publisher database collation along with column-level collation is SQL_Scandinavian_Pref_CP850_CI_AS, whereas the subscriber…
Murali Dhar Darshan
  • 285
  • 1
  • 17
0
votes
1 answer

Getting SQL Server instance name from tcp port number

I have a scenario, in which I am using -q option to change the collation of SQL Server Instance. The command is as follows: sqlservr.exe -m -T4022 -T3659 -s"SQLexpress" -q"SQL_Latin1_General_CP1_CI_AI" The above command works perfectly, where I…
Murali Dhar Darshan
  • 285
  • 1
  • 17
1
2