Collation refers to a set of rules that determine how data is sorted and compared.
Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it …
mysql sql collationI have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored procedures I …
sql sql-server sql-server-2008 sql-server-2012 collationI have just installed PhpMyAdmin v4.1.5 English only I have set it up to access 2 servers - the local one …
php mysql phpmyadmin collationFor a poor man's implementation of near-collation-correct sorting on the client side I need a JavaScript function that does efficient …
javascript sorting string collationI know, I know with what I wrote in the question I shouldn't be surprised. But my situation is slowly …
sql-server tsql collationI'm querying a SQL Server database that uses the SQL_Latin1_General_CP850_BIN2 collation. One of the table rows …
sql-server character-encoding collationJust got this answer from a previous question and it works a treat! SELECT username, (SUM(rating)/COUNT(*)) as TheAverage, …
mysql collation mysql-error-1267I am working on a view, wherein I am using an inner join on two tables which are from two …
sql-server database collationI've recently installed SQL Server 2008 and I selected collation as case sensitive. I want to make it case insensitive for …
sql-server sql-server-2008 collationIs there a rule when we must use the Unicode types? I have seen that most of the European languages (…
sql-server unicode collation nvarchar