Tag Info

New answers tagged

0

Check This answer: change database, table and column collation http://stackoverflow.com/questions/5906585/change-database-collation


0

Since nobody answer the question and I finally figured it out. I'll answer my own question and hope it may help someone later. Data is being inserted by stored procedure, alter dababase, table charset and collations will not override charset and collation setting in stored procedure, nor the changes in my.cnf. After all the database chartsets, collations ...


0

could you compare using binary but return the string? Something like select * from math where symbols = '𝕂' COLLATE utf32_bin is how it would be done in MSSQL.


3

From 10.1.14.1 Unicode Character Sets in the MySQL 5.5 Reference Manual (emphasis added): For supplementary characters in general collations, the weight is the weight for 0xfffd REPLACEMENT CHARACTER. For supplementary characters in UCA collations, their collating weight is 0xfffd. That is, to MySQL, all supplementary characters are equal to each other, ...


2

I had to do this some years ago for a SQL Server 2005 DB. It was awful. I've not had to do it on 2008, thankfully, but as far as I know it still works the same way. Unless specified explicitly, the collation is copied from the next higher object when an object is created. So creating a table will copy the database's collation. Collations are not ...


2

Why does SQL convert Unicode 9619 to ASCII code 166? SQL Server is not employing any special custom logic here; it is using standard operating system services to perform the conversion. Specifically, the SQL Server type and expression service (sqlTsEs) calls into OS routine WideCharToMultiByte in kernel32.dll. SQL Server sets the input parameters to ...



Top 50 recent answers are included