> why does this
> select * from event where room_name =
> 'A Test Room ';
>
> return the same as this
>
> select * from subevent where room_name =
> 'A Test Room';

It is standard behaviour of '=' operator.
To take trailing spaces into account use LIKE operator:
select * from event where room_name LIKE
'A Test Room ';

Ivan