"č" converted to "c" when querying through SQL Server 2008
When Selecting/Inserting into my SQL Server 2008 database, Central European characters are being converted.
For example:
Select 'Kutenič'
Returns:
Kutenic
Why is this? And how can I prevent this from happening? Would my ASP.NET Web Application have a similar problem?
Solution
Use the N prefix
Select N'Kutenič'
Without it the string will be cast to the code page of your database's default collation.
Or set your database's default collation to one of the following if that is more appropriate for your locale.
Albanian_X
Albanian_100_X
Bosnian_Latin_100_X
Croatian_X
Croatian_100_X
Czech_X
Czech_100_X
Estonian_X
Estonian_100_X
Hungarian_X
Hungarian_100_X
Hungarian_Technical_X
Hungarian_Technical_100_X
Latvian_X
Latvian_100_X
Lithuanian_X
Lithuanian_100_X
Polish_X
Polish_100_X
Romanian_X
Romanian_100_X
Serbian_Latin_100_X
Slovak_X
Slovak_100_X
Slovenian_X
Slovenian_100_X
Turkmen_100_X
SQL_Croatian_CP1250_X
SQL_Czech_CP1250_X
SQL_Estonian_CP1257_X
SQL_Hungarian_CP1250_X
SQL_Latin1_General_CP1250_X
SQL_Latin1_General_CP1257_X
SQL_Latvian_CP1257_X
SQL_Lithuanian_CP1257_X
SQL_Polish_CP1250_X
SQL_Romanian_CP1250_X
SQL_Slovak_CP1250_X
SQL_Slovenian_CP1250_X
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by