How to make case insensitive like match?

Hot to make 'LIKE' matching case insensitive for non english characters? I tried

WHERE  NAME  LIKE ? COLLATE NOCASE OR NUMBER  LIKE ? OR  NOTE  LIKE ? COLLATE NOCASE