jnealand,
This is just an implementation detail. Warning!! I am about to go technical, so if you are not technically inclined, I may lose you for a minute! The table structure of effects is as follows (with one exception for single strand which I will discuss as well) : there is a header table that has basic information about the effect (effect_name, username, effect id, etc.) and there is a detail table that has the individual elements (variables) that are set for that effect. When you type in the effect name, it sets effect name as you type it for a variable named "Name" in the detail table and sets an upper-case version of the same name for effect_name in the header table. As far as the database is concerned, these are two separate things (even though we know they are not).
Just to finish the technical portion of this post, the exception is with single strand which uses the two structures (header and detail) -- as discussed above -- but adds another table called segments into the mix. This holds the details of each segment (color, direction, pixel count, etc.) and is specific to single strand effects.
The short answer to your question is that name is from effects detail and effect_name is from effect header (or it may be the other way around, frankly, I have already forgotten which is which) and the reason for the difference between the two.
Not sure about the multiple line thing. Is this because you have effect names that are really long? I will check this logging in as you. Should be a simple fix (like making the window larger, for example).
Kurt