I'm writing an application that needs to be run in Oracle and SQL Server and needs to support AL16UTF16 and UTF-8 character sets respectively. I need a column that could be up to 4000 characters or greater, so I was going to map the text type to a NCLOB and NTEXT (oracle/Sql Server) column. But i was then told by people that you can't use an NTEXT in a where clause - which was then later restated by saying that SQL Server will apparently allow for up to 4000 characters but Oracle does not.

My question is has anyone tried creating NTEXT or NCLOB columns larger than 4000 characters and including them in a where clause. For example "where body like '%hibernate%'" and body is an NTEXT column. Does hibernate handle this situation?

Any help would be greatly appreciated.