certain collation: use Cake\Database\Expression\IdentifierExpression; $collation = 'Latin1_general_CI_AI'; //sql server example $query = $cities->find() ->where(function (QueryExpression $exp, Query $q) IdentifierExpression('name', $collation), '%São José%'); }); # WHERE name COLLATE LIKE Latin1_general_CI_AI "%São José%" Automatically Creating IN Clauses When building queries using the ORM, you will generally this: msgid "My name is {0}" msgstr "Je m'appelle {0}" msgid "I'm {0,number} years old" msgstr "J'ai {0,number} ans" Note Translations are cached - Make sure that you always clear the cache after making

certain collation: use Cake\Database\Expression\IdentifierExpression; $collation = 'Latin1_general_CI_AI'; //sql server example $query = $cities->find() ->where(function (QueryExpression $exp, Query $q) IdentifierExpression('name', $collation), '%São José%'); }); # WHERE name COLLATE LIKE Latin1_general_CI_AI "%São José%" 360 Chapter 12. Database Access & ORM CakePHP Cookbook Documentation, Release 5.x Automatically this: msgid "My name is {0}" msgstr "Je m'appelle {0}" msgid "I'm {0,number} years old" msgstr "J'ai {0,number} ans" 143 https://en.wikipedia.org/wiki/Gettext 144 https://github.com/cakephp/localized

certain collation: use Cake\Database\Expression\IdentifierExpression; $collation = 'Latin1_general_CI_AI'; //sql server example $query = $cities->find() ->where(function (QueryExpression $exp, Query $q) IdentifierExpression('name', $collation), '%São José%'); }); # WHERE name COLLATE LIKE Latin1_general_CI_AI "%São José%" Automatically Creating IN Clauses When building queries using the ORM, you will generally this: msgid "My name is {0}" msgstr "Je m'appelle {0}" msgid "I'm {0,number} years old" msgstr "J'ai {0,number} ans" Note Translations are cached - Make sure that you always clear the cache after making

certain collation: use Cake\Database\Expression\IdentifierExpression; $collation = 'Latin1_general_CI_AI'; //sql server example $query = $cities->find() (continues on next page) More Information 459 CakePHP IdentifierExpression('name', $collation), '%São José%'); }); # WHERE name COLLATE LIKE Latin1_general_CI_AI "%São José%" Automatically Creating IN Clauses When building queries using the ORM, you will generally this: msgid "My name is {0}" msgstr "Je m'appelle {0}" msgid "I'm {0,number} years old" msgstr "J'ai {0,number} ans" 157 https://en.wikipedia.org/wiki/Gettext 158 https://github.com/cakephp/localized

this: msgid "My name is {0}" msgstr "Je m'appelle {0}" msgid "I'm {0,number} years old" msgstr "J'ai {0,number} ans" Extract Pot Files with I18n Shell To create the pot files from __() and other internationalized

this: msgid "My name is {0}" msgstr "Je m'appelle {0}" msgid "I'm {0,number} years old" msgstr "J'ai {0,number} ans" 162 https://en.wikipedia.org/wiki/Gettext 163 https://github.com/cakephp/localized