{"id":294,"date":"2018-03-14T15:41:14","date_gmt":"2018-03-14T15:41:14","guid":{"rendered":"http:\/\/www.eyurtsever.com\/?p=294"},"modified":"5194-03-14T15:41:14","modified_gmt":"5194-03-14T15:41:14","slug":"mssql-collation-degistirme","status":"publish","type":"post","link":"https:\/\/www.eyurtsever.com\/index.php\/mssql-collation-degistirme","title":{"rendered":"MSSQL Collation De\u011fi\u015ftirme"},"content":{"rendered":"<p>MSSQL collaction de\u011fi\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki kodlar New Query penceresine yazabilirsiniz.<\/p>\n<pre class=\"brush:vb\">ALTER DATABASE databaseadi_eyurtsever SET SINGLE_USER WITH ROLLBACK IMMEDIATE\nALTER DATABASE databaseadi_eyurtsever COLLATE TURKISH_CI_AS\nALTER DATABASE databaseadi_eyurtsever SET MULTI_USER<\/pre>\n<p>Veritaban\u0131n\u0131n collation degerini de\u011fi\u015ftirdik. Fakat tablolardaki alanlar\u0131n collation degerini de de\u011fi\u015ftirmek gerekiyor. Tabloyu design modunda a\u00e7t\u0131ktan sonra alan \u00f6zelliklerinde collation de\u011ferini &#8220;restore default&#8221; yap\u0131n. Bunu her alan i\u00e7in yapmak gerekiyor.<br \/>\nTek tek bununla u\u011fra\u015fmak istemiyorsan\u0131z , veritaban\u0131n\u0131 olu\u015ftururken &#8220;options&#8221; se\u00e7ene\u011finden \u00a0<strong>collation<\/strong> de\u011ferini belirleyin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL collaction de\u011fi\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki kodlar New Query penceresine yazabilirsiniz. ALTER DATABASE databaseadi_eyurtsever SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE databaseadi_eyurtsever COLLATE TURKISH_CI_AS ALTER DATABASE databaseadi_eyurtsever SET MULTI_USER Veritaban\u0131n\u0131n collation degerini de\u011fi\u015ftirdik. Fakat tablolardaki alanlar\u0131n collation degerini de de\u011fi\u015ftirmek gerekiyor. Tabloyu design modunda a\u00e7t\u0131ktan sonra alan \u00f6zelliklerinde collation de\u011ferini &#8220;restore default&#8221; yap\u0131n. Bunu her alan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12,13],"tags":[96,211,212,215,298,336],"_links":{"self":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/294"}],"collection":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/comments?post=294"}],"version-history":[{"count":0,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/294\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/media?parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/categories?post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/tags?post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}