According to the Canadian Criminal Code, (self-induced) intoxication is no defence against charges of assault (33.1): if you’re drunk, you’re still able to form the general intent to commit said assault.
And yet, with regard to the sub-category of sexual assault, belief that someone is consenting is cancelled if that someone is intoxicated (273.1(2)): if …