What was Charlie's life long dream which he hoped night school would help?

Charlie wanted to learn even though his intellect was challenged. This says that Charlie had a desire to learn and better himself.

Charlie's dream about being chased by a bloody knife and losing something after he is sexually aroused by a woman expresses his fear of emasculation should he give in to his sexual urges.