Make UPPER and LOWER work on MS SQL Server text and ntext columns

Description

Trying to use UPPER or LOWER on a text column results in:

ERROR util.JDBCExceptionReporter - Argument data type text is invalid for argument 1 of upper function.

http://databases.aspfaq.com/database/why-do-i-get-argument-data-type-text-is-invalid-for-argument.html suggests a workaround, which I think should be automatically used by Hibernate, so that the HQL query can work with other dialects.

Environment

MS SQL Server

Assignee

Strong Liu

Reporter

Sergiu Dumitriu

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

Affirmative

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure