Me and the Mrs went there a couple of years ago. Beautiful city and you only see the red light district if you want to go there.
We stayed at a hotel opposite the main train station called the park plaza Victoria