On 9/10/08, Sheeri K. Cabral <[EMAIL PROTECTED]> wrote: > > On 9/10/08, Brian Aker <[EMAIL PROTECTED]> wrote: >> >> Hi! >> >> Does anyone have any input on cast and convert? These seem to have a >> number gotchas in them, and I wondering how folks are using these in >> practice. Keep in mind, we are UTF8 internal, so some of the "usefull-ness" >> goes away when it comes to comparison operations. The date to string looks >> useful, but I can think of better ways of doing the queries that are >> suggested in the comments. >> >> Cheers, >> -Brian > > > When used implicitly, they're bad most of the time. > > However, I don't think we can get rid of them completely. you mentioned > date to string (and string to date, I'm not sure why we need to have it be a > string at all, except in the output formatting -- if we got rid of that it > would fix the 0 = 0000-00-00 00:00:00 issues)... > > are we keeping any BINARY functions? Certainly if we're case-comparing > stuff, CAST can be useful... >
Sorry, trigger finger happened early. Damn Gmail. :) Seriously, though....for the most part it can go away, and be added back as a UDF if we really need it. I think replication has many hacks that depend on crappy functions like that, maybe I'm thinking of something like CONVERT though? It's all the same evil stuff to me. It's like having a bad employee....."So I told him to do this, only he did that instead...." -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
