---
F R E N D Z of martian
---
Support status: closed
Problem: User error in name
Outcome: Dispatched deed poll form
----- Original Message -----
From: John O'Callaghan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 08, 2000 5:30 PM
Subject: The web and Irish names
> ---
> F R E N D Z of martian
> ---
> Dear Frendz of marsbard
> Can anyone explain why the Web does not like Irish names.
>
> my surname is O'Callaghan
>
Crappy coding - apostrophes break SQL ("insert into names (surname) values
('O'Callaghan')" - as you can see there's a disparity of apostrophes - SQL
will stop after 'O' and see an unknown command "Callaghan" and die. Which is
why it has to be escaped "insert into names (surname) values
('O\'Callaghan')" (backslash) or "insert into names (surname) values
('O''Callaghan')" (double) dependent on the server
> but ntl have it has O%27Callaghan
If this happened to be in the WebTV part of ntl I could probably get it
fixed as I know a contractor there.
> compfutures made it O\"\"Callaghan
stupid escape... shoot the coders
> and quite a few have just choked
didn't anticipate any names with apostrophes...
>
> Is an a apostrophe really that difficult to deal with?
> or is it just lazy script writers only going for A-Z ?
>
> I know that it is a perl script thing the %27 thing (please correct me if
I
> am wrong)
URL-escaped apostrophe
> but a decent explaination would be nice.
>
> the last thing you want is a load of angry Irish surfers!
>
> Thanx in advance
> John
>
>
>
>
> --
> Sent to you via the frendz list at marsbard.com
>
> The archive is at http://www.mail-archive.com/[email protected]/
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/[email protected]/
