columnDefinition = "TEXT" for all types of databases

Question

Locally I use mysql, so when I use

 @Column(columnDefinition = "TEXT")

Unfortunately application have to run at different databases too, I've not been told which ones just "at all".

Is it possible to make something with similar effect, but working at most of databases? How can I achieve it?

Answer 1

What about something like this:

@Lob
private String someString;

I think it's more portable and should effectively generate TEXT or LONGTEXT data type.