http://www.sqlite.org/datatype3.html#collation and http://stackoverflow.com/questions/4917545/android-sort-sqlite-query-results-ignoring-case
İyi Çalışmalar Dilerim. Saygılar, ------------------------------------------------------------------------- Fikret AKIN Senior .Net Developer | Software Projects Developer VengaSoft - Software Developer mobile: +90 (534) 700-75-19 web : www.fikretakin.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of mcxxx Sent: 26 Nisan 2012 Perşembe 16:36 To: [email protected] Subject: [mono-android] Sqlite like i,ü,I,İ problem? select *from table where colum like %ir% as a result of this query ====> "öz" "cesur" How can I cope with this problem? #region usings using System; using System.Data.SQLite; #endregion #if MONO using Mono.Data.Sqlite; #else #endif namespace ASC.Data.SQLite { #if MONO [SqliteFunction(Name = "upper", Arguments = 1, FuncType = FunctionType.Scalar)] #else [SQLiteFunction(Name = "upper", Arguments = 1, FuncType = FunctionType.Scalar)] #endif public class UpperFunction : #if MONO SqliteFunction #else SQLiteFunction #endif { public override object Invoke(object[] args) { if (args.Length == 0 || args[0] == null) return null; if (args[0] == DBNull.Value) return DBNull.Value; return ((string) args[0]).ToUpper(); } } } these codes do not work. What should I expect your help. -- View this message in context: http://mono-for-android.1047100.n5.nabble.com/Sqlite-like-i-u-I-problem-tp5667630p5667630.html Sent from the Mono for Android mailing list archive at Nabble.com. _______________________________________________ Monodroid mailing list [email protected] UNSUBSCRIBE INFORMATION: http://lists.ximian.com/mailman/listinfo/monodroid _______________________________________________ Monodroid mailing list [email protected] UNSUBSCRIBE INFORMATION: http://lists.ximian.com/mailman/listinfo/monodroid
