MSSQL 和 REDIS的数据类型对应关系

           when user_type_id in (34) then 'BLOB' --image
            when user_type_id in (35) then 'CLOB' --text 
            when user_type_id in (48) then 'TINYINT' 
            when user_type_id in (52) then 'SMALLINT' 
            when user_type_id in (56) then 'INTEGER' --tinyint
            when user_type_id in (58,61) then 'DATE' --smalldatetime,datetime
            when user_type_id in (59,60,122) then 'REAL' --real,monery,smallmoney
            when user_type_id in (62) then 'FLOAT' --float
            when user_type_id in (99) then 'NCLOB' --ntext
            when user_type_id in (104) then 'BIT' --bit
            when user_type_id in (106) then 'DECIMAL' --decimal
            when user_type_id in (108) then 'NUMERIC' --numeric
            when user_type_id in (127) then 'BIGINT' --bigint
            when user_type_id in (165) then 'VARBINARY' --varbinary
            when user_type_id in (167) then 'VARCHAR' --varchar
            when user_type_id in (173) then 'BINARY' --binary
            when user_type_id in (175) then 'CHAR' --char
            when user_type_id in (189) then 'TIMESTAMP' --timestamp
            when user_type_id in (231) then 'NVARCHAR' --nvarchar
            when user_type_id in (239) then 'NCHAR'--nchar