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=-1
order by ct.typeName COLLATE PinYin
View Code
