The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
69 views

MySQL character-set-server won't take effect

I'm trying to have my MySQL server use UTF8 as the default collation and character set. I am able to set everything except for the character_set_server which always takes 'latin1' as value. I have ...
3
votes
1answer
163 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
5
votes
3answers
2k 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
1answer
327 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
217 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
185 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, ...
0
votes
1answer
473 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
201 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
816 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 ...
10
votes
2answers
672 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
684 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 ...
6
votes
1answer
5k 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
366 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
2k 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
361 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
355 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 ...
12
votes
4answers
12k 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
2k 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
420 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 ...
13
votes
6answers
32k 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
927 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 ...