Question

which data type could be used for the field Remark or comment​

Answer 1

Answer:

It depends on what you want to do with them, and the chracter set in which they've been encoded. While CLOB/NCLOB types may seem attractive, they are not nearly as efficent as [N]VARCHAR for most of the functions you would usually want to run on them, and anyone who can't comment in 2000 or 4000 characters isn't likey to generate a comment you'd want to use anyway.

HOPE THIS HELPS YOU........