[zekus]

Sometimes you need to use a different COLLATE, to do a select for example, and be case sensitive or accent sensitive.
At the moment this is not possible using the query builder unless you write you own plain sql query.
I think it would be a good idea to add a method like collate() or something generic like additional() (or something like that) that allow to attach non standard statements like COLLATE to the generated query.
I hope I have been clear enough explaining the case.

[samdark]

Can you check how to achieve that for MySQL, SQLite, PostgreSQL, MSSQL and Oracle?

[zekus]

samdark, on 08 December 2011 - 11:27 AM, said:

Can you check how to achieve that for MySQL, SQLite, PostgreSQL, MSSQL and Oracle?

From a simple google search, this is what I have found:

MySQL http://dev.mysql.com...et-collate.html
MSSQL http://msdn.microsof...y/ms184391.aspx
SQLite http://www.sqlite.or....html#collation
PgSQL http://www.postgresq.../collation.html
Oracle http://docs.oracle.c...v.htm#sthref362

[klammeraffe]

zekus, on 08 December 2011 - 06:26 AM, said:

or something generic like additional() (or something like that) that allow to attach non standard statements like COLLATE to the generated query

Or different sorting options like

SORT BY row DESC NULLS LAST

for example.

I think that would be quite useful.

[yJeroen]

Can't you already add these things with CDbCriteria methods? And the sort by nulls last using a CSort?