Closed

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

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.

Skills: Java, Programming, Software Development, Coding

See more: websites type text displayed, net documentviewer type text find, type text external file flash, invalid argument supplied foreach joomla help, dolphin boonex type text, option type text oscommerce, data mining text resume parsing, type text file, text data type sql server hibernate spring, psd text column, phone notify type text free, excel macros type text website, excel vba column contains text column contains number, extract data as400 text file, search data input text as3, script type text file, change data type excel column, script data cfasync false type text javascript src http www adnetworkperformance com a display php r 315076 script p script src

About the Employer:
( 1 review ) Belfast, United Kingdom

Project ID: #27547661

2 freelancers are bidding on average £35 for this job

Larisawebdev

Dear client. > I 'm glad to see you. I'm PHP developr that have 4+ years. I saw your desciptions and it 's very interesting. I 'm professional developer and have many experience. I can make new site and cutomize the More

£50 GBP in 1 day
(1 Review)
2.4
globalTSolutions

Hi, I can do this,. It is a known issue with Linq and there is a workaround. Would you be able to share the repo and the model class you have. Let's have a quick chat on how to proceed. Thanks

£20 GBP in 1 day
(0 Reviews)
0.0