> home
> how we work
> who we're working for
> about us
> publications
> buy apache essentials
> client login

play
static·red
edmonton and area web development

Current Projects

Edmonton Weather


>>Le blog.

speakeasy archives


I hate SQL

<< so much for academic freedom... | Main | further proof... >>

title says it all.... it seems that if it's not an alphanumeric character, SQL barfs on it. If you manage to save it as a hexidecimal value, you then need to convert it BACK when you pull it OUT of the database.

How can you tell I just spent the last 2 hours trying to get the database to store a double-quote?

Posted by Darren James Harkness on Thursday, August 22, 2002 03:20 PM
Trackbacks...


Comments:
>> Darren » Thursday, August 22, 2002 03:37 PM

Ah... but as I've mentioned before with this project, things would be soooo much easier if I could use the built-in PHP functions, rather than a proprietary interface... ;)

>> Kethryvis » Thursday, August 22, 2002 05:26 PM

Funny... my problem with SQL was getting it to *strip* extra double-quotes. it was sticking extra ones in all over the place. Took us a few days to get rid of them all. Grr. :)

>> Wim » Friday, August 23, 2002 12:58 AM

SQL as in SQL the language? quote handling can differ between databases... I can't remember having hastles with Oracle/Postgres/Mysql/MSSQL though. Or maybe I did a quick =~ s/"/\"/ or something. PHP is silly :-)

>> fozbaca » Monday, August 26, 2002 12:06 PM

Scrap the PHP shit and drop the crapy MSSQL, then replace with Perl, DBI and Postgres. And if the copany needs some help with the switch I'm avialbe as a consulant, resonable rates :)

>> Darren » Monday, August 26, 2002 12:08 PM

Sadly, the established criteria for this project was interoperation with Interbase and a proprietary interfact with it at that.


Post a comment









 Remember personal info?


Comments:
* under no circumstances will your email address be traded for a sack of quarters. No-sirree.

The content on this site is licensed under a Creative Commons license.