Beer or wine can be used, you will want them to be warm. Surprisingly you will get quite drunk. Possibly you will be dangerously drunk so you should be careful. It is a good idea to mix wine at half-strength the first time you use alcohol in an enema.

Alcohol is absorbed much more quickly in the intestines than in the stomach, so you need to be really careful.

Using hard alcohol is NOT A GOOD IDEA. You can die from this.

It might be worth a mention that mixing drugs (alcohol in this case) and strange medical procedures can be a bad idea.