SQLite中文排序

SQLite中文排序定义一个类：

using System.Data.SQLite;namespace DAL{ /// <summary> /// SQLite中文排序 /// </summary> [SQLiteFunction(FuncType = FunctionType.Collation, Name = "PinYin")] public class SQLitePinYingSort : SQLiteFunction { public override int Compare(string x, string y) { return string.Compare(x, y); } }}

View Code在Global.asax.cs文件的application_Start方法中添加如下代码：

SQLiteFunction.RegisterFunction(typeof(SQLitePinYingSort)); //使SQLite支持中文排序

SQL代码：

select ct.* from mas_channel_type ct where ct.pId=-1order by ct.typeName COLLATE PinYin

View Code