Try this one – Query: DECLARE @collate SYSNAME SELECT @collate=”Cyrillic_General_CS_AS” SELECT ‘[‘ + SCHEMA_NAME(o.[schema_id]) + ‘].[‘ + o.name + ‘] -> ‘ + c.name , ‘ALTER TABLE [‘ + SCHEMA_NAME(o.[schema_id]) + ‘].[‘ + o.name + ‘] ALTER COLUMN [‘ + c.name + ‘] ‘ + UPPER(t.name) + CASE WHEN t.name NOT IN (‘ntext’, ‘text’) THEN … Read more
Here’s how I’d do it – For Schemas (or Databases – they are synonyms): SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = “mydatabasename”; For Tables: SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = “mydatabasename” AND T.table_name = “tablename”; For Columns: SELECT character_set_name FROM information_schema.`COLUMNS` WHERE table_schema = “mydatabasename” AND table_name … Read more
For single table you can do something like this: ALTER TABLE tab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; For the whole database I don’t know other method than similar to this: http://www.commandlinefu.com/commands/view/1575/convert-all-mysql-tables-and-fields-to-utf8
You basically need to run the installation again to rebuild the master database with the new collation. You cannot change the entire server’s collation any other way. See: MSDN: Setting and changing the server collation How to change database or server collation (in the middle of the page) Update: if you want to change the … Read more
It depends on what you need. The utf8_bin collation compares strings based purely on their Unicode code point values. If all of the code points have the same values, then the strings are equal. However, this falls apart when you have strings with different composition for combining marks (composed vs. decomposed) or characters that are … Read more
Collation tells database how to perform string matching and sorting. It should match your charset. If you use UTF-8, the collation should be utf8_general_ci. This will sort in unicode order (case-insensitive) and it works for most languages. It also preserves ASCII and Latin1 order. The default collation is normally latin1.
You need to choose an Arabic collation for your varchar/char columns or use Unicode (nchar/nvarchar) CREATE TABLE #test ( col1 VARCHAR(100) COLLATE Latin1_General_100_CI_AI, col2 VARCHAR(100) COLLATE Arabic_CI_AI_KS_WS, col3 NVARCHAR(100) ) INSERT INTO #test VALUES(N’لا أتكلم العربية’,N’لا أتكلم العربية’,N’لا أتكلم العربية’) Note the N before values in insert statement above. If you do not mention it, … Read more
Well, you can read about the differences in the documentation. I can’t tell you what you should be using because every project is different. 10.1.3 Collation Naming Conventions MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, followed by one or more … Read more
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS
The thing about collations is that although the database has its own collation, every table, and every column can have its own collation. If not specified it takes the default of its parent object, but can be different. When you change collation of the database, it will be the new default for all new tables … Read more