{"version":"1.0","provider_name":"Sage CRM \u2013 Tips, Tricks and Components","provider_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm","title":"SageCRM and SQL Collation setup - Sage CRM \u2013 Tips, Tricks and Components","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"TTOiErtele\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/\">SageCRM and SQL Collation setup<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/06\/sagecrm-and-sql-collation-setup\/embed\/#?secret=TTOiErtele\" width=\"600\" height=\"338\" title=\"&#8220;SageCRM and SQL Collation setup&#8221; &#8212; Sage CRM \u2013 Tips, Tricks and Components\" data-secret=\"TTOiErtele\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","description":"While installing older versions of CRM i.e. v7.1 Sp1 or below the installation process in background checks the SQL Server collation defined at database server and accordingly it maps the same collation to CRM database. If the collation at SQL level is not defined correctly same reflects to CRM database as well. Because of this\u2026 Read More &raquo;","thumbnail_url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/IMG.jpg"}