When you are handling string you sometime have single quote in your string. I was looking on how to handle that in Oracle and it’s not pretty but you can cover that case with the chr(39) function, 39 being the code for the single quote. So it you are looking the “it’s” you have to […]
I had in the past had to work with oracle and had to convert it to mysql. Unfortunately (or fortunately) that project was cancel but here are the bit of information I’ve found that I didn’t know about and made me lost a lot of time. Oracle vs mySQL datatype edition From mySQL […]
The to_date function we talked earlier make a come back. The wrong way to do it is : SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = ’12-04-27′ you end up comparing string in that case to work you need to do the following: SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = […]
I was having problem making one of my SQL query work in ORACLE until I realize that I got the check on the date wrong. It seem that Oracle didn’t interpreted my query has I expected when handling a date with a greater or lesser than operator (< or >). So this won’t work : […]
Really quick post to a problem I’ve got un hibernate when converting to mySQL, I’ve found that the problem was because we were using a generator class “sequence” and in mySQL we needed to use “assigned” or “increment” instead. Note you might not have that problem in your project but that was preventing me from […]
I’ve stumbled upon that problem recently and couldn’t remember how to do it. Has you except it’s trivial to do and like most of what can be done in programming there more than one way to do it. 1- Good old jdk String 🙂 Since Java 1.5 you have the new String format method do […]
http://blog.foundersnetwork.com/2013/01/how-quora-sent-us-82-10-of-our-visitors/ Story of a startup and how quora helped them bring visitors to the site. http://slant.co/topics/what-is-the-best-architecture-for-building-a-web-service/ soap vs rest… basicly every new provider use rest now a day… http://antjanus.com/blog/seo/running-a-blog-what-i-did-wrong-and-right-in-2012/ incredible journey from 0 to 20k visitor/month. What really interesting is how he self-evaluate himself, that really important. Many point are really good to […]
Microsoft study: Linux migration cost Munich €60.7 million (h-online.com) This article really caught my attention, because a government agency (Munich city administration’s) want to get rid of Microsoft and they’re not replacing it with the bloated IBM or Oracle solution and because Microsoft did a study to show how much it cost them (that stink […]
Recent Comments