You need to understand a few things about night photos. You need a certain amount of light on the sensor. And when there is not enough light, you need to make a longer exposure. This means that the subject you are photographing must either stand still, or you get it blurred from the motion of the subject. Since you mention clubs, there will be subject motion.
So, you either need to flash, or you need a high ISO which does not produce a ridiculous amount of noise.
There is only one compact that will let you use higher ISO with not too much noise, the Fuji Z1/Z2.
If you do not mind the flash, the Canon SD500/550 has better image quality than the Sony's you listed. And about your video remark, no idea where you got that from.
If you do not mind flash but do dislike red eye effects from the flash, the only camera that is both very compact and does good in that area is the Sony DSC-P200.
But since flash will ruin club atmospheres, I think your best bet will be the Fuji Z1/Z2.
__________________
Canon EOS 350D, Tamron SP AF 90mm F/2.8 macro, Sigma 18-50mm F2.8 DC EX, Canon EF 70-200mm f/4 L USM, Tokina AT-X124 Pro 12-24mm F4, Soligor 1.7x C/D4 DG Teleconvertor, Manfrotto 724B tripod, Canon Powershot S30
High ISO:
+Enables faster shutter, probably will reduce motion blur, both hands or subject, lighting still natural
-Noise, Sony cameras typically have acceptable ISO400, while Fuji have ISO800, which is 1 stop advantage (1 stop means you can shoot at 2X faster shutter speed)
Image Stabilization:
+Reduces handshake motion blur up to 3 full stops (e.g. without IS you shot at 1/60, then with IS you shot at 1/60 : 2 : 2 : 2 = around 1/8), lighting still natural
-Cannot freeze subject movement, e.g. running man
For me, I prefer the IS, because I don't shoot many action low light shots, most are still like sceneries and city lights. IS gave me 3 stop advantage, while Fuji cameras have low noise up to ISO800 have only 1 stop advantage over the sony.
capedeci, the ISO 400 is NOT acceptable and if you would bother to look at the reviews from Jeff Keller you would know that.
And since the asking person mentions clubs, why do you respond the way you do? It all is irrelevant. I really do not understand you.
Since ISO 400 on the T models is really not good, they are in no way a good choice for this person. Simple as that.
With the T9 you are unable to choose the shutter speed, so Jeff did not get to even make the usual night ISO shots.
The N1 does this:
The SD550 does this:
and the Z1 (so also the Z2) does this:
Not hard to see why I recommended the Z1/Z2 to this person, now is it?
__________________
Canon EOS 350D, Tamron SP AF 90mm F/2.8 macro, Sigma 18-50mm F2.8 DC EX, Canon EF 70-200mm f/4 L USM, Tokina AT-X124 Pro 12-24mm F4, Soligor 1.7x C/D4 DG Teleconvertor, Manfrotto 724B tripod, Canon Powershot S30
If it was between the models you listed, I'll definitely go for the Sony T9, Image Stabilizer really help when taking building/city views at night.
I thought I said "between the models you listed", T9 is the best.
Acceptable or not, its subjective man, I think ISO400 on most sonys are acceptable, and most panasonics are not acceptable.
For you, probably Canon 20D is what defines acceptable.
He listed that models, maybe he didnt want the bigger size and uglier design of the fuji.
I said that I prefer T9, over fuji, just for input for him, I don't ask him to choose the same thing as me. The IS allows 3 stops of handholdable shutter speed advantage, while ISO offer 1 stop shutter speed advantage, and this is not taking noise into account. Once again, I assume anyone wanting a small slim camera don't want to carry a tripod
You do not listen/read/comprehend. He mentions clubs!
What do they do in clubs, do you think? Stand still? NO. They move.
So what do you suggest? Image stabilization over better ISO performance.
Really capedeci, get real. IS is useless for this person. And you are being quite irritating in your way of giving advice, where you only look at your OWN preferences and not what others actually need, what their requirements are.
What made you get banned on dpreview anyway?
__________________
Canon EOS 350D, Tamron SP AF 90mm F/2.8 macro, Sigma 18-50mm F2.8 DC EX, Canon EF 70-200mm f/4 L USM, Tokina AT-X124 Pro 12-24mm F4, Soligor 1.7x C/D4 DG Teleconvertor, Manfrotto 724B tripod, Canon Powershot S30
I prefer IS over a 1 stop ISO advantage. But I prefer a 3 stop ISO advantage over IS.
I got banned for fighting with another version of you And upon irritation, consult with a physician
If you cannot take my presence on this forum anymore, please notify the administrators, and ask them to review my posts that irritated you, so they can do something to me. Thanks.
I've just re-read my first reply, and I really don't find anything wrong. I suggest T9 over the other options he stated, then I said my personal preference, as well as my reason, it made things clear...I think.
Sony T9 vs T5 vs T7 vs T11 vs N1 ??
And upon irritation, consult with a physician 
Linear Mode
