“Well, my Raspberry Pi camera B (the one with adjustable focus) worked just fine with normal cable connected to a Raspberry Pi 2. Once I connected it with the adapter cable to Pi Zero W a short circuit probably was created somewhere, the camera overheated, Pi Zero W didn't boot (obviously the entire current went through the short circuit). I realised that after few seconds and it was too late. The camera still works with normal cable and Raspberry Pi 2 BUT the image is blurry (the image taken with raspistill) , I'm not able to adjust it in any way so it's basically broken. It's 3/5 because I'm not sure if it's the adapter cable (checked with multimeter seemed ok to me) or the CSI interface on a brand new Pi Zero W.”
“Adapter works as expected. Although small I had little trouble getting it into the connector on either the Pi or the camera module. However there was no guidance on which way around the cable had to go. The trick is that the metal contacts on the cable should face the PCB on both the Pi and the camera module.”