The collation tag has no wiki summary.
3
votes
2answers
124 views
SQL Server Collation settings for System Center Service Manager 2012
There is a lot of conflicting or confusing information surrounding the required collation settings for SQL Server, as it pertains to hosting the SCSM 2012 database and associated data warehouse ...
0
votes
0answers
42 views
Selecting Collation for International application [closed]
We are installing a new SQL Server 2012 Enterprise that is to be deployed in different countries around the world. All the servers is going to share data in real time, and the application is ...
0
votes
1answer
185 views
Is it possible to install SQL instances with different Collations in a SQL Cluster
We have a two node active-active SQL Server 2008 Cluster. Running on Windows Server 2008 R2.
The three excisting instances have Latin1_General_CI_AS as the Server Collation. I need to add an instance ...
0
votes
2answers
158 views
Does SQL Server 2008 collation matter for storing non-English characters in TFS 2008?
There are compilation issues in our TFS builds since some non-English characters are not recognized. Could this be caused by SQL Server collation? Its been installed as SQL_Latin1_General_CP1_CI_AS ...
3
votes
1answer
167 views
MySQL think 'außer' equals to 'auser'
I tried to migrate some tables from one MySQL database to the other, but I encountered an error:
ERROR 1062 (23000) at line 108: Duplicate entry 'außer' for key 'PRIMARY'
And I tried to find why, ...
1
vote
1answer
329 views
Gerrit uses wrong collation
I'm trying to authenticate Gerrit users using ldap against Active Directory.
I get the following error.
ERROR com.google.gerrit.server.cache.PopulatingCache : Cannot lookup ...
3
votes
3answers
140 views
How to set sort(1) to use a custom collation?
I have a text file containing one record per line which I'd like to sort alphabetically, except that I want '-' to sort after '[' and ']'. (The natural sort order has '-' before the square brackets.) ...
0
votes
1answer
722 views
Illegal mix of collations in mysql php query
I am receiving a "Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='" error when executing a MySQL query in PHP. The odd thing is that the exact ...
8
votes
2answers
461 views
Is there a MySQL performance benchmark to measure the impact of utf8_unicode_ci versus utf8_general_ci?
I read here and there that using the utf8_unicode_ci collation ensures a better treatment of unicode text (for example, it knowns how to expand characters such as 'œ' into 'oe' for searching and ...
1
vote
3answers
584 views
Perfectly reproducable select statement default ordering issue
I've recently been chasing an issue with a client's db... solution found, but impossible to recreate.
Essentially, we're doing a
Select * from mytable where ArbitraryColumn = 75
Where MyTable has ...
2
votes
1answer
3k views
Change collation of a MySQL table to utf8_general_cs
I tried to change collation MySQL table to utf8_general_cs but got following error:
mysql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_cs';
ERROR 1273 (HY000): ...
0
votes
1answer
338 views
how to check the charset and collation of mysql database?
how to check the charset and collation of mysql database? or what command to the charset and collation of mysql database?
Thanks
0
votes
1answer
1k views
SQL Server; how to import data from another DB with different collation; conversion errors?
I have 2 databases setup on a server. I want to import data from DB1 to DB2, using the SSIS wizard (right click DB > Tasks > Import Data)
DB1 is the source DB, it has a collation set to ...
3
votes
2answers
340 views
Potential issues with SharePoint 2007 and SQL Server default collation?
SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, ...
0
votes
5answers
313 views
Does the mysql table type matters?
I am new to mysql. Along create the project, I didnt pay attention to tables type and collation type. Now, I already have 20 tables, 15 tables are MyISAM type, the rest are innoDB type. I notice my ...
9
votes
3answers
9k views
Alter charset and collation in all columns in all tables in MySQL
I need to execute these statements in all tables for all columns.
alter table table_name charset=utf8;
alter table table_name alter column column_name charset=utf8;
Is it possible to automate this ...
0
votes
2answers
1k views
How to change the collation of a table/column?
I know, there is the database configuration parameter "Database collating sequence" for setting the collation in db2. But since this effects the whole database and can only be set when creating it, ...
7
votes
3answers
1k views
Is there an easier way of resolving SQL Server/database collation mismatches than changing every column?
DISCLAIMER: I know that this question has been asked a hundred times before, but I just wanted to check that there wasn't an easier solution I might have missed before I went ahead and wrote/sourced ...
1
vote
3answers
394 views
How do I change the system wide collation setting in SQL Server 2005
I've got a recently upgraded SQL Server which I'm getting ready to put live, we've gone from SQL Server 2000 to SQL Server 2005. The collation setting on the 2005 box is different though (I didn't do ...
1
vote
3answers
2k views
Which Collation should we use for a web application - SQL Server 2005
We'd like to use the equivalent to UTF-8, but Can't seem to find the appropriate option within SQL Server 2005. Any thoughts on which we should use?
1
vote
4answers
2k views
How to convert an MS SQL 2005 DB from Collation SQL_Latin1_General_CP1_CI to SQL_Latin1_General_CP1_C1_AS?
How can I convert an MS SQL 2005 DB from collation SQL_Latin1_General_CP1_CI to SQL_Latin1_General_CP1_C1_AS?
SQL_Latin1_General_CP1_C1_AS does not appear in the list of options when I go to:
Right ...
12
votes
6answers
24k views
How do I change the collation of a SQL Server Database?
I'm trying to standardise all databases on a single collation - Latin1_General_CI_AS (the standard collation). I have some databases that are in SQL_Latin1_General_CP1_CI_AS.
I know I can use ALTER ...
1
vote
3answers
902 views
SQL Server 2005 collation issues
I've got a SQL Server 2005 database that has been built using a different collation from the one one our servers. I'm getting this error whenever I try and run the site:
Exception message: Cannot ...
