Any message you compose that has 480 characters or more will be converted into an MMS. This is a restriction on SMS technology
Handecent will switch off the stock notification for you.
Start Handcent.
Menu - settings
Application Settings
Default Messaging Application
Select "All (SMS & MMS)"...