raindropz12 Posted April 26, 2011 Share Posted April 26, 2011 May I know when we should set data type to varbinary? Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/ Share on other sites More sharing options...
fenway Posted April 26, 2011 Share Posted April 26, 2011 When you want variable-length BINARY data -- which shouldn't be stored in the DB anyway. Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/#findComment-1206396 Share on other sites More sharing options...
raindropz12 Posted April 26, 2011 Author Share Posted April 26, 2011 When you want variable-length BINARY data -- which shouldn't be stored in the DB anyway. did you mean binary data will not be stored in the DB if the type is set to varbinary? Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/#findComment-1206412 Share on other sites More sharing options...
fenway Posted April 27, 2011 Share Posted April 27, 2011 It will be stored if you store it -- but binary data shouldn't be in a database, as a general rule. Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/#findComment-1206869 Share on other sites More sharing options...
raindropz12 Posted April 28, 2011 Author Share Posted April 28, 2011 It will be stored if you store it -- but binary data shouldn't be in a database, as a general rule. why there's varbinary data type then? Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/#findComment-1207334 Share on other sites More sharing options...
fenway Posted April 30, 2011 Share Posted April 30, 2011 Because you can store it there, if you prefer -- it's just not advisable. Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/#findComment-1208717 Share on other sites More sharing options...
raindropz12 Posted May 24, 2011 Author Share Posted May 24, 2011 ok thank you. Quote Link to comment https://forums.phpfreaks.com/topic/234742-varbinary-help/#findComment-1219558 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.