Please help about enable identifier quoting

[luyen...@gmail.com]

Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

[Chris]

Hi,

edit your site's configuration file and set the option `Datasources.default.quoteIdentifiers` to true

ROOT/config/settings.php

for instance:

<?php

 return array (

  'Datasources' => 

  array (

    'default' => 

    array (

      'className' => 'Cake\\Database\\Connection',

      'driver' => 'Cake\\Database\\Driver\\Mysql',

      'database' => 'quickapps2',

      'username' => 'root',

      'password' => '',

      'host' => '127.0.0.1',

      'port' => '3306',

      'prefix' => '',

      'encoding' => 'utf8',

      'timezone' => 'UTC',

      'log' => false,

      'cacheMetadata' => true,

      'quoteIdentifiers' => true,

    ),

  ),

  'Security' => 

  array (

    'salt' => '__SALT_',

  ),

  'debug' => false,

);

[luyen...@gmail.com]

Hi Chris,

Thanks you for your helping

Br,

LuyenLV

[luyen...@gmail.com]

Hi Chris,

I performed as your suggestion but it's not works.

I'm changed the words on my content manager site from 'create new' to 'Tạo mới'.

Notice (8): iconv(): Detected an illegal character in input string [ROOT/plugins/Search/src/Model/Behavior/SearchableBehavior.php, line 768]

Could help me?

On Friday, November 27, 2015 at 5:42:03 PM UTC+7, luyen...@gmail.com wrote: