Author Topic: Query Contacts with UTF-8 special characters (Read 566 times)

pederb · June 19, 2013, 06:56:42 am

Why can't CiviCRM API find Contact records when searchvalue contains special characters as Ä..?
Everything works fine with "normal" characters.

Code:
...
$params['last_name'] = 'Ägir';
$res = civicrm_api('contact','Get',$params);

Searchvalue is UTF-8, read from UTF-8 file with parsecsv.
Sourcecode files are UTF-8 with BOM.
Database and tables are utf8_unicode_ci.

pederb · June 20, 2013, 07:04:05 am

I debugged and found out that the error relates to the fact that string-values are converted to lowercase when building the SQL where clause.

In the function buildClause in CRM_Contact_BAO_Query we have the following code:

if ($dataType == 'String') {
$value = "'" . strtolower($value) . "'";
}

Shouldn't this be mb_strtolower...?
I have tried to change it and it works.

CiviCRM Community Forums (archive)

News:

Author Topic: Query Contacts with UTF-8 special characters (Read 566 times)

pederb

Query Contacts with UTF-8 special characters

pederb

Re: Query Contacts with UTF-8 special characters