Linked by Eugenia Loli-Queru on Thu 17th Jun 2004 21:11 UTC
Today we features a mini-Q&A with Alex Roedling, MySQL's Senior Product Manager, about all things MySQL, the competition, technology, licensing and more.
Permalink for comment
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
Recent Original Stories
Recent Comments
Headlines
Random Comments
Random Stories
Random OS Link
That's like saying that it's OK if your filesystem were to randomly truncate files or mix two files together. Because, hey, it works and it's fast and who cares if you lose a few bits here and there?
The analogy is wrong. There's nothing random here - MySQL behavior is documented and known. If MySQL truncates strings longer than the column they are stored into, then you know exactly what is going on and can adapt your programs accordingly. There's only data loss if you agree to it. If your code is proper (ie : checks string length before storing them) it will work equally well with MySQL or another database.
As a sidenote MSDOS used to truncate filenames to 8 chars (the tragedy !).