Currently, the best way for you to do this is to implement a plain SQL
condition as documented here:
http://www.jooq.org/doc/3.2/manual/sql-building/plain-sql/
For example:
Condition condition = DSL.condition("{0} COLLATE utf8_bin",
T1.COL1.eq(T2.COL1));
The same can be done directly in .on() and .where() clauses:
DSL.using(configuration)
.select(...)
.from(T1)
.join(T2).on("{0} COLLATE utf8_bin", T1.COL1.eq(T2.COL1)))
...
I will see whether it makes sense to add support for the COLLATE clause in
the jOOQ API in general:
https://github.com/jOOQ/jOOQ/issues/2908
Cheers
Lukas
2013/12/20 Jeremy Ross <[email protected]>
> How can I included a COLLATE clause after a text comparison expression?
> Current situation is a JOIN condition, e.g.:
>
> INNER JOIN T2 ON T1.COL1 = T2.COL1 COLLATE utf8_bin
>
> Also need to be able to do this in WHERE clauses.
>
> Thanks.
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
