Tagged Questions
1
vote
2answers
395 views
Correct Code Page or Collation in SQL Server for Portuguese characters
I'm inserting data (Bulk insert and merge update) for a Portuguese data source (CSV files) into my database. Although the DB collation is Latin1-General, case-insensitive, accent-sensitive, ...
1
vote
0answers
309 views
Server Collation Change Error
I am using following command to change the collation of my SQL Server R2 (10.50.1600):
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SQLSYSADMINACCOUNTS=sa /SAPWD=**** ...
1
vote
1answer
315 views
Design SQL Server 2008 new install … which collation?
A customer has a SQL Server 2005 instance, collation SQL_Latin1_General_CP1_CI_AS, with 8 databases ... for a new application, we have been asked to install a SQL Server 2008 with collation ...
6
votes
1answer
10k views
SQL Server 2005/2008 UTF-8 Collation/Charset
I can't find option(s) directly to set UTF-8 rellated Collations/Charsets in SQL Server 2005/2008, same as is possible to set in another SQL engines, but in SQL Server 2005/2008 are there only Latin ...
2
votes
2answers
2k views
SQL Server 2008 collation arabic
We are currently having a problem loading arabic into a SQL Server 2008 database.
We want to load
بِسْمِ اللَّهِ الرَّحْمَٰنِ الرَّحِيمِ
but in the database it changes to
بِسْمِ اللَّهِ ...
6
votes
1answer
392 views
Dependant T-SQL comparison collation
Is there any way to set the collation for a string comparison based on an independent variable or column value? Something akin to
SELECT COL1, col2
FROM [TABLE]
WHERE COL3 LIKE '%string%'
...
16
votes
3answers
22k views
How to change SQL Server collation
How could I change the SQL Server 2008 R2 Express Default Collation for the whole server and a particular database?
Is there a way to do it using visual interface of SQL Server Management Studio? In ...
