Find Jobs
Hire Freelancers

TEXT column: Argument data type text is invalid for argument 1 of lower function 2

£10-20 GBP

已完成
已发布超过 3 年前

£10-20 GBP

货到付款
I currently have a repo method which is acting as a filter with pagination: Repo: @Query("SELECT e FROM DeTest e " + "WHERE [login to view URL] = '9999-12-31 00:00:00.000' " + "AND (:name is null OR LOWER ([login to view URL]) LIKE LOWER ('%' + :name+ '%')) " + "AND (:description is null OR LOWER ([login to view URL]) LIKE LOWER ('%' + :description + '%')) " + "AND (:theProblem is null OR LOWER ([login to view URL] ) LIKE LOWER ('%' + :theProblem + '%')) " ) So as shown here, I have it so when you enter a value it will change it ensuring that both uppercase values and lowercase values are displayed. However, when adding LOWER to the 'theProblem' column, it produces the error in the title: Argument data type text is invalid for argument 1 of lower function My datatype for that particular column is text, and therefore, I think the culprit of the issue. However, due to the db layout I need it to be a text. Therefore, is there anyway I could convert/cast it in the repo method for when it's called? Column: @Column(name = "the_problem", columnDefinition = "TEXT") // text rather than varchar private String theProblem; Thank you.
项目 ID: 27548647

关于此项目

3提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I have 8+ years of experience in .net, JS, SQL and DB related changes. Please revert and contact for further communication.
£16 GBP 在3天之内
0.0 (0条评论)
0.0
0.0
3威客以平均价£18 GBP来参与此工作竞价
用户头像
Hi, I am confident I can fix this query for you, I have often had to deal with similar issues with a TEXT column from older versions of SQL server when TEXT was the only option. I have 11 years experience as a SQL Developer and DBA, please feel free to ask any questions.
£17 GBP 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED KINGDOM的国旗
Belfast, United Kingdom
0.0
0
付款方式已验证
会员自8月 5, 2020起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。