So much fun exporting data from MSSQL Express to PostgreSQL.
So the MSSQL "Save Results As..." feature from the query editor window allows export as csv - which is a step in the right direction, but still pathetic in it's options [ie: none]
However the encoding appears to be UTF-16, I don't know if this is database derived or if it forces encoding at export time [I have no interest in learning more about MSSQL unless it's absolutely necessary, out of the gate I despise it with a deep and abiding loathing]
When attempting to prep the exported csv with a simple php script to insert the data into a holding table, I was appalled to find out that there were encoding artifacts *in between every character* [my ignorance of UTF-16 encoding shines here... I'm assuming it's a multibyte character encoding byte of some sort] - long story short, the data needs further intervention before it's ready to import/insert into a UTF-8 PostgresSQL database table.
TextWrangler to the rescue:
Using the Zap Gremlins function I was able to eradicate all non ascii characters from my dataset - which in this instance was fine as I'm doing very rudimentary and gross information prep.
daily collapse
Tuesday, May 1, 2012
Monday, April 2, 2012
Josh Garrels
Loving Josh Garrels - certain songs from his new album don't do anything for me, but there's at least four [and especially one, "white owl" ] that I find mesmerizing.
http://joshgarrels.com/
Album is available for download on bandcamp...
http://joshgarrels.bandcamp.com/
http://joshgarrels.com/
Album is available for download on bandcamp...
http://joshgarrels.bandcamp.com/
Thursday, March 8, 2012
Have some art
yes have some.
Some sketches from various projects both personal and commissioned. Not really anything too impressive, I really need to work harder on my technique and get some color work done. I always draw initially on Canson Tracing paper because I love the way the way pencil looks on it. [Not to mention if I make significant progress on a piece and want to change it I can trace multiple versions very rapidly] I usually use a .3 mechanical pencil, and using a paper with too much roughness really wears through lead quickly. Also the bite of something heavier like Bristol Board will tend to snap the thinner lead easily with my heavy hand.
Some sketches from various projects both personal and commissioned. Not really anything too impressive, I really need to work harder on my technique and get some color work done. I always draw initially on Canson Tracing paper because I love the way the way pencil looks on it. [Not to mention if I make significant progress on a piece and want to change it I can trace multiple versions very rapidly] I usually use a .3 mechanical pencil, and using a paper with too much roughness really wears through lead quickly. Also the bite of something heavier like Bristol Board will tend to snap the thinner lead easily with my heavy hand.
Friday, January 6, 2012
Piracy Policy
You can't pirate what's freely given... unless of course you're wearing an eye patch or something, then just looking at this [with your good eye] is piracy. Owning a parrot [or lobster], or having missing appendages also makes you a pirate. In the absence of parrot/lobster and eye patch, or presence of limbs, you can be temporarily qualified as a pirate by simply saying "ARRGH" once or twice. That is all.
Wednesday, December 21, 2011
You must increase in awesomeness until your will is utterly spent.
This will be what amounts to the tired rants concerning the discordant interests of a socially inept and disconnected geekobot, although perhaps therein something wonderful will have occurred. That much shall be left to retrospect.
Subscribe to:
Comments (Atom)




