Simple answer:
Both are Scart.
RGB: The scart end is full of pins with nothing missing.
Composite Scart: The scart end has pins missing.
Although just because you have RGB Scart doesn\'t mean your TV will benefit, you need a TV which has an RGB scart socket, otherwise the picture will just be the same as composite scart.