MySql 5 will not allow you to insert a large blob

using mysql 5 , i tried to insert a large stream and found out that i have to set a variable in my.ini file. the variable takes a value in bytes as following :


max_allowed_packet='value'



for example, for 100MB :


max_allowed_packet=104857600