人大金仓sqlserver兼容版 转换varchar 默认varchar(30)导致查询报错 返回
SqlSugar
沟通中
2
213
飞 发布于2周前
悬赏：0 飞吻
.netCore+sqlsugar+人大金仓sqlserver兼容版。 SqlFunc.ToString
转换后语句
SELECT "A"."USERNAME" AS "NAME" , "A"."USERLOGINID" AS "CODE" , CAST("B"."BUSINESSROLEUSERID" AS VARCHAR) AS "ID" FROM "USR_USER" "A" Inner JOIN "BUSINESSROLEUSERS" "B" ON (CAST("B"."USERID" AS VARCHAR) = "A"."USERID" ) WHERE ( "B"."BUSINESSROLEID" = 'FC77EB4F-9E97-45F2-9DAC-2EB9C2ABF0DE')
提示：too long varchar(30)
数据库字段是uniqueidentifier 类型
热忱回答（2）
-
fate sta VIP0
1周前我处理一下
0 回复 -
fate sta VIP0
1周前
你应该是databasemodel没有配置 ，走了金仓 oracle模式逻辑
0 回复