<p>CK Editör kullananlar bilirler türkçe karakter kayıtlarında harfleri tuhaf karakterlere döndürür. Bunun için sql de bir function tanımladım, geçmiş kayıtlarımı bu sorgu ile düzelttim.</p> <blockquote> <p>alter FUNCTION ed_turkcedon<br /> (<br /> &nbsp; &nbsp; @param1 &nbsp;nvarchar(max)<br /> )<br /> RETURNS nvarchar(max)<br /> AS<br /> BEGIN</p> <p>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;DECLARE @Sayac INT = 1;</p> <p>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;DECLARE @metin nvarchar(max);<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;WHILE @Sayac &lt; 15 BEGIN ;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;uuml;&#39;,&#39;ü&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;Ouml;&#39; , &#39;Ö&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;ouml;&#39; , &#39;ö&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;ccedil;&#39; , &#39;ç&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;Ccedil;&#39; , &#39;Ç&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;thorn;&#39; , &#39;ş&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;yacute;&#39; , &#39;ı&#39; )<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;Yacute;&#39; , &#39;&Uuml;&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;ETH;&#39; , &#39;Ğ&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;THORN;&#39; , &#39;Ş&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;Yacute;&#39; , &#39;İ&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;thorn;&#39; , &#39;ş&#39;)<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS , &#39;&amp;eth;&#39; , &#39;ğ&#39; )<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;set @param1=Replace(@param1 COLLATE SQL_Latin1_General_CP1254_CS_AS ,&#39;&amp;yacute;&#39; , &#39;ı&#39;)</p> <p>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;SET @Sayac += 1;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;END;</p> <p><br /> &nbsp; &nbsp; RETURN @param1&nbsp;</p> <p>END</p> </blockquote> <p>Updates ;&nbsp;</p> <blockquote> <p>&nbsp;UPDATE BLogs&nbsp;<br /> &nbsp;set Aciklama=eray.ed_turkcedon(Aciklama)<br /> &nbsp; where Id=692</p> </blockquote>