Skip to main content

Posts

Showing posts from September, 2013

Oracle - How to insert a string longer than 4k using C#

And this is another PITA sponsored by our good friends of Oracle ;)
After being struggling whit this issue for a whole day, I finally figure it out. There is a bunch of posts on the web saying that you should change the column type on the table from let’s say LONG to CLOB or stuff like that… but I have tried it and it has no effect if you are working with C# (maybe make sense if you are working with PL. I’m not sure, haven’t test it). The thing is even if you change the column type, you’ll still get an error saying “the string literal is too long…” The way to insert strings larger than 4K into Oracle databases is using bindings. And yes, you can insert 4k plus strings into LONG columns, there is no such 4k limit. This is how you do that:


* I skip error handling, disposing objects, etc… just for brevity, of course you shouldn't ;)
Another interesting thing that almost every posts got wrong is that you don’t have to specify the parameter type, the library will choose the right type…

How to upgrade an Acer Aspire V5 122P to SSD

Just two weeks ago I've upgrade my Acer v5 to SSD, and to my surprise, by following these tutorials, everything worked as expected ;)
http://www.youtube.com/watch?v=z8OJTZGdVq4
http://www.youtube.com/watch?v=ZBJsh-lkQt8
http://www.youtube.com/watch?v=dm7xY_hviaY
For those who doesn’t know about the Acer Aspire V5, I think it’s the cheapest touchscreen Win8 ultrabook on the market. I forced myself to use it as development machine (running visual studio 2012, R#, SQL Server and all that stuff) and for 450 bucks, it’s more than I expected.
The touchpad is decent enough (although it can be better), the keyboard works great and by throwing another 100 for a SSD into the mix, increased the overall system performance, making the Acer a budget dev machine.
The only drawbacks I found so far it’s the AMD 1GHz processor (of course you cannot change that) and the plastic case, but for the price I payed for it, I’m more than satisfied. If you are on a budget, I highly recommend the Aspire v5.