I am planning on building a plugin and i need to know if the data stored in the options table i will create for the plugin will be serialized or it will be in the ordinary sql format.
It totally depends on what data is being stored in the option,
Hope that helps..
EDIT: Confirmed - checked source, above information is correct regarding serialization.
I am pretty sure it is searilized.
update_option() function serailizes the data passed.
The get_option() function deseralizes it.
Depends on some factors.
If you're storing options in the db trough WP's API, like using add_option() then the data is automatically serialized by WP if the option is a array.
(same happens in widgets)
If you don't want serialized data then just don't pass arrays to add_option. If you have multiple options you could serialize it yourself and send it as a string before you pass it to the function...