tag:blogger.com,1999:blog-6915277641954268020.post6465203798819501662..comments2023-10-06T15:31:18.343-07:00Comments on Through The SQL: Boolean Field in Visual Foxpro and MS SQL ServerGlen villarhttp://www.blogger.com/profile/06615152653077171813noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6915277641954268020.post-62601208802446650602019-08-15T11:31:06.263-07:002019-08-15T11:31:06.263-07:00All these theoretical discussions are great, but i...All these theoretical discussions are great, but in reality, at least if you're using MySQL and really for SQLServer as well, it's best to stick with non-binary data for your booleans for the simple reason that it's easier to work with when you're outputting the data, querying and so on. It is especially important if you're trying to achieve interoperability between MySQL and SQLServer (i.e. you sync data between the two), because the handling of BIT datatype is different in the two of them. SO in practice you will have a lot less hassles if you stick with a numeric datatype. I would recommend for MySQL to stick with BOOL or BOOLEAN which gets stored as TINYINT(1). Even the way MySQL Workbench and MySQL Administrator display the BIT datatype isn't nice (it's a little symbol for binary data). So be practical and save yourself the hassles (and unfortunately I'm speaking from experience).<br /><br />https://stackoverflow.com/questions/290223/what-is-the-difference-between-bit-and-tinyint-in-mysql?https://www.blogger.com/profile/09234572481078957718noreply@blogger.comtag:blogger.com,1999:blog-6915277641954268020.post-15057851368155645772019-07-26T22:47:08.563-07:002019-07-26T22:47:08.563-07:00may email was qassemak@gmail.com pleas sent to you...may email was qassemak@gmail.com pleas sent to your Email , I have some problem need help from you<br />regard Anonymoushttps://www.blogger.com/profile/16452563808234821419noreply@blogger.comtag:blogger.com,1999:blog-6915277641954268020.post-67507394273690639092019-07-26T22:45:38.381-07:002019-07-26T22:45:38.381-07:00 I have quotation about the foxpro modify structu... I have quotation about the foxpro modify structure how I can send for you Email <br />pleas write your EmailAnonymoushttps://www.blogger.com/profile/16452563808234821419noreply@blogger.comtag:blogger.com,1999:blog-6915277641954268020.post-48027426420661925882017-07-21T20:51:44.755-07:002017-07-21T20:51:44.755-07:00Hi Williamson,
Thanks you. :)Hi Williamson,<br /><br />Thanks you. :)Glen villarhttps://www.blogger.com/profile/06615152653077171813noreply@blogger.comtag:blogger.com,1999:blog-6915277641954268020.post-39249290753090216492017-07-17T23:03:37.824-07:002017-07-17T23:03:37.824-07:00Very interesting to know details about boolean fie...Very interesting to know details about boolean field in visual Foxpro and MS.<br /><br /><a href="https://www.migrateto.net/vfp-.net-migration" rel="nofollow">Convert Visual FoxPro to .Net</a><br /><br /><a href="https://www.migrateto.net" rel="nofollow">VB6 to VB.Net Migration</a><br /><br /><a href="https://www.migrateto.net/migrate-asp-to-asp-net/" rel="nofollow">ASP to ASP.Net Migration</a>Anonymoushttps://www.blogger.com/profile/11425063045741685284noreply@blogger.com