Does an XLR cable work the same as a DMX cable for lights (e.g. moving heads)?

Hey, I am currently in the process of buying two moving heads for my own events. Now the question arises whether an XLR cable also works for the connection between the lights and the interface (Pioneer RB-DMX1 interface), or whether only the DMX cable works. When I search for a DMX cable for lights on…

Mix DMX 512 and 507?

I have 2 spotlights (eurolite Akku Mini Party RGBW Spot MK2 and fungeneration LED Pot 12x1W QCL RGBWW 15°) the fungeneration always works, regardless of whether I connect controller→eurolight→fungeneration or controller→fungeneration→eurolight, but the eurolite never works. Now I'm thinking that my console is only compatible with DMX512 and not DMX507. Could that be the case?