Tag Info

New answers tagged


First, just to make sure that a collation is available or not, you can test in two ways: Check the list of available collations (i.e. sys.fn_helpcollations()). Running the following query in SQL Server 2012 and 2014 should return 52 rows: SELECT * FROM sys.fn_helpcollations() WHERE [name] LIKE N'ukrain%'; Try using the collation: SELECT N'a' COLLATE ...


Run in PhpMyAdmin: ALTER DATABASE yourdatabasename CHARACTER SET utf8 COLLATE utf8_unicode_ci


You can't install UTF-8 as a character set because it's not a character set, it is an encoding. If you want to store Unicode text you use the nvarchar data type. If you want to store text encoded using UTF-8, you store it as binary data (varbinary).


Given that this is an existing database that already has tables defined in it, there are some very serious implications to the action of changing the database collation, beyond the potential performance impact to DML opertions (which actually was already there). There is very real impact to performance and functionality, and this change not only did not ...


Collations in SQL Server determine the rules for matching and sorting character data. Normally, you would choose a collation first based on the comparison semantics and sorting order the consumers of the data require. Humans generally do not find that binary collations produce the sorting and comparison behaviours they expect. So, although these offer the ...

Top 50 recent answers are included