New answers tagged

1

LOBs are managed in chunks (groups of blocks), not blocks, so there's not really anything to gain with this. Oracle assumes that an 8k block size is "universally good" for everything. By increasing the block size, you could potentially wind up wasting storage space that can't be efficiently allocated for smaller files because the chunk size is too ...


0

Unfortunately the answer to when a NoSQL database system is better than a RDBMS is a little subjective which is why it's highly debated. A lot of misinformation has caused the incorrect connotation that a NoSQL database is faster than a RDBMS, particularly with big data, which isn't necessarily true. This connotation is based on the origination story of ...


0

Put images separately; reference them via <img ...> in HTML. Period, end of discussion. (If it is not HTML, then perhaps this is not the 'right' answer.)


0

You could certainly meet your requirements with SQL Server if you use Filestream or FileTable. to quote from the linked article :- The goals of the FileTable feature include the following: Windows API compatibility for file data stored within a SQL Server database. Windows API compatibility includes the following: Non-transactional streaming access and in-...


0

This is what I did that worked on me. On my old database server (where emoji is showing before I migrate), since I just need the field where the emojis are being inputted and the primary key of the row, I created another table with just 2 fields containing the text and the primary key. Then filled it with the data from the old table. After that I perform ...


0

Simply use UNHEX("1E395565"). There could be a lot of other issues going on. So please provide SHOW CREATE TABLE for the old and new tables. Also provide a sample of what is in the old table, but use SELECT col, HEX(col) FROM ... WHERE ... so we can see the value in an unambiguous way. (That is, not mangled or "fixed" by the client.) ...


Top 50 recent answers are included