In https://forum.phalconphp.com/discussion/1810/orm-collate-postgresql- you describe how to use collate with PG however I would like to ask you if there is anyone who can add COLLATE expression to version 1.3.5 and 2.x?
With MSSQL adapter and dialect is possible use COLLATE in WHERE condition only when you write whole SQL manually but it brings more issues with function call in columns. With ORM I get following error: unexpected token IDENTIFIER(COLLATE), What I found problem is in internal parser where you dont count with COLLATE in WHERE condition. Reason why I need COLLATE before LIKE expression is simple - people find records in DB with or without accents so I wanted simply replace:
$_conditions = $queryField . " LIKE '%" . $_filter->value ."%'";
$_conditions = $queryField . " COLLATE Latin1_general_CI_AI LIKE '%" . $_filter->value . "%'";
Does anybody can help me with this problem? Its long time ago I made anything with lexical analyzator.