Server Error in '/' Application.

Illegal mix of collations (latin5_turkish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'(SELECT * FROM yayinevi where (adi like '%ÜMMÜ’L-KURÂ%' or keyw like '%ÜMMÜ’L-KURÂ%' or descx like '%ÜMMÜ’L-KURÂ%') )

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Illegal mix of collations (latin5_turkish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'(SELECT * FROM yayinevi where (adi like '%ÜMMÜ’L-KURÂ%' or keyw like '%ÜMMÜ’L-KURÂ%' or descx like '%ÜMMÜ’L-KURÂ%') )

Source Error:


Line 80:     }*/
Line 81: 
Line 82:     public static DataTable GetDataTable(string sql) { MySqlConnection Baglan = baglanti.Baglan(); MySqlDataAdapter adapter = new MySqlDataAdapter(sql, Baglan); DataTable dt = new DataTable(); try { adapter.Fill(dt); } catch (MySqlException ex) { throw new Exception(ex.Message + "(" + sql + ")"); } finally { adapter.Dispose(); Baglan.Close(); } return (dt); }
Line 83:     public static DataRow GetDataRow(string sql)
Line 84:     {

Source File: c:\inetpub\vhosts\manayayinlari.com\httpdocs\App_Code\baglanti.cs    Line: 82

Stack Trace:


[Exception: Illegal mix of collations (latin5_turkish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'(SELECT * FROM yayinevi where (adi like '%ÜMMÜ’L-KURÂ%' or keyw like '%ÜMMÜ’L-KURÂ%' or descx like '%ÜMMÜ’L-KURÂ%') )]
   baglanti.GetDataTable(String sql) in c:\inetpub\vhosts\manayayinlari.com\httpdocs\App_Code\baglanti.cs:82
   konudetay.yayinevi(String metin) in c:\inetpub\vhosts\manayayinlari.com\httpdocs\konudetay.aspx.cs:72
   konudetay.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\manayayinlari.com\httpdocs\konudetay.aspx.cs:51
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0