CLOB ORACLE (LARAVEL TEXT DATATYPE) FAILS AT ORDER (ORA-00932: inconsistent datatypes: expected - got CLOB) and query join searchs fails. about laravel-datatables

[yajra]

As the error stated, you cannot order on clob datatype. However, you can use orderColumn and add a custom sql for it to work. Maybe something like:

->orderColumn('description', "DBMS_LOB.SUBSTR(description) $1")

[nirvale]

->orderColumn('description', "DBMS_LOB.SUBSTR(description) $1")

wow, I did read it into documentation, and... I didn't it, my mistake, I'm sorry... orderColumn it works, ayway... order by text column, and search into a text column into a datatable maybe is a not very efficient proccess with a larger tables to try in web, I will not do it any more but is good to know how doit.

Thank you.
``