{"id":1050,"date":"2014-08-19T17:50:55","date_gmt":"2014-08-19T15:50:55","guid":{"rendered":"http:\/\/marwin.e-blog.cz\/?p=1050"},"modified":"2015-07-16T12:06:57","modified_gmt":"2015-07-16T10:06:57","slug":"how-change-ms-sql-collation-jak-zmenit-ms-sql-collation","status":"publish","type":"post","link":"https:\/\/svobodma.cz\/?p=1050","title":{"rendered":"How change MS SQL Collation, JAK zm\u011bnit MS SQL Collation"},"content":{"rendered":"<p><a href=\"http:\/\/marwin.e-blog.cz\/?attachment_id=1054\" rel=\"attachment wp-att-1054\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1054 alignnone\" alt=\"SQL_Server\" src=\"http:\/\/marwin.e-blog.cz\/marwin.e-blog.cz\/httpdocs\/wp-content\/uploads\/SQL_Server.jpg\" width=\"115\" height=\"94\" \/><\/a><\/p>\n<p>Jednou jsem takhle prov\u00e1d\u011bl n\u011bjak\u00e9 testov\u00e1n\u00ed <strong>vype\u010den\u00e9<\/strong> aplikace a kdy\u017e se mi ji neda\u0159ilo nainstalovat, zjistil jsem, \u017ee m\u00e1m v MS SQL nastaveno \u0161patn\u011b Collation (ve zkratce. &#8211; pou\u017e\u00edv\u00e1 se pro \u00a0\u0159azen\u00ed znak\u016f v MS SQL). No nejsem MS SQL guru a tak jsem up\u0159\u00edmn\u011b poprv\u00e9 na n\u011bco takov\u00e9ho narazil. \u00a0V minulosti se prost\u011b nevyskytla chybka ohledn\u011b t\u00e9to konkr\u00e9tn\u00ed v\u011bci a tak nebylo t\u0159eba se \u00a0ji zab\u00fdvat. Jen\u017ee co kdy\u017e u\u017e m\u00e1te MS SQL server nainstalovan\u00fd a nakonfigurovan\u00fd ? \u00a0Server se d\u00e1 reinstalovat, co\u017e jsem stejn\u011b nakonec ud\u011blal :), proto\u017ee jsem si vybral i \u0161patnou verzi MS SQL, \u00a0ale Collation se d\u00e1 zm\u011bnit i bez reinstalace MS SQL.<\/p>\n<p>Proto\u017ee jsem dnes op\u011bt instaloval MS SQL server pro otestov\u00e1n\u00ed app a op\u011bt jsem narazil na \u0161patn\u00fd v\u00fdb\u011br Collation v MS SQL serveru, rozhodl jsem se pod\u011blit se a vlo\u017eit na tyto str\u00e1nky postup, \u00a0jak lze Collation rychle zm\u011bnit. Zde je prov\u011b\u0159en\u00fd postup.<\/p>\n<p>&nbsp;<\/p>\n<p>1. Zastavte v\u0161echny MS SQL slu\u017eby \/ (stop all MS SQL services )<\/p>\n<p>2. V p\u0159\u00edkazov\u00e9 \u0159\u00e1dce <strong>cmd.exe<\/strong> pod administr\u00e1torem spus\u0165te n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz (verzi Collation je na v\u00e1s, j\u00e1 p\u0159ikl\u00e1d\u00e1m tu , kterou jsem pot\u0159eboval) \/ (in <strong>cmd.exe<\/strong> run command let below)<\/p>\n<p>Setup \/QUIET \/ACTION=REBUILDDATABASE \/INSTANCENAME=<strong>&lt;InstanceName&gt;<\/strong><br \/>\n\/SQLSYSADMINACCOUNTS=<strong>&lt;AdminAccount&gt;<\/strong> \/[SAPWD=<strong>&lt;Password&gt;<\/strong><br \/>\n\/SQLCOLLATION=Latin1_General_CI_AS<\/p>\n<p>3. Spus\u0165te v\u0161echny MS SQL slu\u017eby \/ ( start all MS SQL services)<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/svobodma.cz\/?attachment_id=1181\" rel=\"attachment wp-att-1181\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1181\" alt=\"MSSQLCollation\" src=\"http:\/\/svobodma.cz\/marwin.e-blog.cz\/httpdocs\/wp-content\/uploads\/MSSQLCollation.png\" width=\"656\" height=\"328\" srcset=\"https:\/\/svobodma.cz\/marwin.e-blog.cz\/httpdocs\/wp-content\/uploads\/MSSQLCollation.png 1094w, https:\/\/svobodma.cz\/marwin.e-blog.cz\/httpdocs\/wp-content\/uploads\/MSSQLCollation-150x75.png 150w, https:\/\/svobodma.cz\/marwin.e-blog.cz\/httpdocs\/wp-content\/uploads\/MSSQLCollation-560x280.png 560w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jednou jsem takhle prov\u00e1d\u011bl n\u011bjak\u00e9 testov\u00e1n\u00ed vype\u010den\u00e9 aplikace a kdy\u017e se mi ji neda\u0159ilo nainstalovat, zjistil jsem, \u017ee m\u00e1m v MS SQL nastaveno \u0161patn\u011b Collation (ve zkratce. &#8211; pou\u017e\u00edv\u00e1 se pro \u00a0\u0159azen\u00ed znak\u016f v MS SQL). No nejsem MS SQL &hellip; <a href=\"https:\/\/svobodma.cz\/?p=1050\">Cel\u00fd p\u0159\u00edsp\u011bvek <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1050","post","type-post","status-publish","format-standard","hentry","category-others"],"_links":{"self":[{"href":"https:\/\/svobodma.cz\/index.php?rest_route=\/wp\/v2\/posts\/1050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/svobodma.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/svobodma.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/svobodma.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/svobodma.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1050"}],"version-history":[{"count":7,"href":"https:\/\/svobodma.cz\/index.php?rest_route=\/wp\/v2\/posts\/1050\/revisions"}],"predecessor-version":[{"id":1182,"href":"https:\/\/svobodma.cz\/index.php?rest_route=\/wp\/v2\/posts\/1050\/revisions\/1182"}],"wp:attachment":[{"href":"https:\/\/svobodma.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/svobodma.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/svobodma.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}