Thank you for that explanation, Miyako!
From: Keisuke Miyako via 4D_Tech <[email protected]> Cc: Keisuke Miyako <[email protected]> > 2019/08/29 12:31ÅAwebmaster namethatplant.net > <[email protected]>ÇÃÉÅÅ[Éã: > > I still have a question. > The write-up for PROCESS HTML TAGS contains the warning, "It is now highly > inadvisable to store texts in BLOBs". > > I don't use the command "PROCESS HTML TAGS" but I have used BLOB variables in > several other places throughout my website. These don't contain any > troublemaker characters and they are working well. > > Do I need to convert them to text variables? storing text in BLOB is inadvisable for several reasons: BLOBs are not ref-counted and memory inefficient. there are copied when passed as a method argument, for example. BLOB to text conversion is costly, especially when the storage encoding is not UTF-8 (unicode to unicode conversion is quite efficient) there is not inherent size advantage compared to text. BLOB assumes that a byte is your atomic data unit, which is not true for Unicode you are denied access to essential text commands such as position, match regex, replace string, etc. but if things are working well, of course you don't need to convert them. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
