Unexpected strcmp behaviour with strings containing backticks

Question

I'm facing a strange problem with the strcmp function. I need to compare 2 strings containing the backtick character (`):

$result = strcmp('CREATE TABLE `postsTranslations` (', 'CREATE TABLE `posts` (');

I expected that the result of this comparison should be >0 since postsTranslations is alphabetically after posts. But the result is -1. If I remove the backticks, everything works as expected. Would it be possible to alphabetically compare these strings without removing backticks?

Answer 1

You need to use strcasecmp here. It does the binary safe case-insensitive string comparison.