rise-worlds

GO
PRINT N'Creating [SQL_CLR_Functions]...for SQL Server 2005, 2008, and 2008 R2';

GO
CREATE ASSEMBLY [SQL_CLR_Functions]
    AUTHORIZATION [dbo]
    FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300DE1E2C550000000000000000E00002210B010B000008000000060000000000002E270000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000D42600005700000000400000C802000000000000000000000000000000000000006000000C0000009C2500001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000034070000002000000008000000020000000000000000000000000000200000602E72737263000000C80200000040000000

rise-worlds

public static class SignatureExtensions
{
    static Dictionary<string, string> avatars = new Dictionary<string, string>();

    public static string GetAvatar(this String email, int size = 75)
    {
        string key = email + "_" + size;
        if (!avatars.ContainsKey(key))
        {
            string avatar = "//www.gravatar.com/avatar/";

rise-worlds

//全角字符的定义为 unicode编码从0xFF01~0xFF5E 对应的半角字符为 半角字符unicode编码从0x21~0x7E,空格比较特殊, 全角为0x3000, 半角为0x20；除空格外, 全角/半角按unicode编码排序在顺序上是对应的
//首先,全角字符在utf-8下是三个字节表示,,具体表示为 1110xxxx 10xxxxxx 10xxxxxx

//所以,首先需要解析utf8编码的数据,如果是 FF01 到 FF5E 的情况下,则进行转换


void PreProcessor::half(std::string &input) {
    std::string temp;
    for (size_t i = 0; i < input.size(); i++) {
        if (((input[i] & 0xF0) ^ 0xE0) == 0) {