Searching For a Unicode Character (e.g. the Unicode null)

Question

I need to write a SOQL query that retrieves all accounts with the character '\u0000', i.e. the null character, in their name. I wrote the following code:

final string nullChar = '\u0000';
final string nullCharSearch = '%' + nullChar + '%';
Database.QueryLocator = Database.getQueryLocator(
    'select name from Account where name like :nullCharSearch'
);

However, this does not return any results. Our Account table is very large so it is difficult for me to confirm whether there are indeed no results, or if my query is not behaving correctly. So, the question is, will this code produce the correct results, or do I need to escape or hardcode the unicode?

Answer 1

For some reason, it didn't dawn on me to use an Apex test method to test this:

public static testMethod void nullTest()
{
    final String nullchar = '\u0000';
    final String nullCharSearch = '%' + nullChar + '%';
    Account test = new Account(Name = 'gg\u0000gg');
    insert test;
    List<Account> accnList = Database.query('select Name from Account where Name like :nullCharSearch');
    System.assert(!accnList.isEmpty());
    System.debug(accnList);
}

This test passes and displays the inserted record, so it appears my query was correct.