Welcome to GamesX. The two terms you need to research are PAL and NTSC. The European video standard is known as PAL, and the American one is known as NTSC. So in addition to a different connector, you also have to convert the video signal.
Can you describe the connectors in question, and tell us what year your SNES unit was made? It may be possible for you to connect the system to a modern TV using a different output type without having to bother with converting the video, but without knowing the rest of the information we can't know for sure. Pictures would be helpful too.