ROTECTED]
Sent: Saturday, November 15, 2003 3:20 PM
To: Jason Ramsey; [EMAIL PROTECTED]
Subject: Re: Backslash and full text searches
Hi Jason,
Sorry for the late reply.
If all of the 100,000 entries have extra backslashes, that can be fixed
with a query. But then you have all your code. :-(
Speak
t; From: Jason Ramsey [mailto:[EMAIL PROTECTED]
> Sent: 13 November 2003 22:11
> To: [EMAIL PROTECTED]
> Subject: Backslash and full text searches
>
>
> We make extensive use of full text searches, but have run into
> some problems
> with backslashes. If a word like "s
his is Matt\'s text. |
+---+
1 row in set (0.00 sec)
Matt
- Original Message -
From: "Jason Ramsey"
Sent: Thursday, November 13, 2003 6:41 PM
Subject: RE: Backslash and full text searches
> Thanks for your answer, you can see my comments below.
&g
Thanks for your answer, you can see my comments below.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:36 PM
To: Jason Ramsey; [EMAIL PROTECTED]
Subject: Re: Backslash and full text searches
Hi Jason,
Of course somebody's isn'
quotes_gpc is on and you don't check for that.
Your text should come out exactly the way it was intended. Never, ever
any need for stripslashes(), etc. if it was inserted correctly. :-)
Hope that helps.
Matt
----- Original Message -
From: "Jason Ramsey"
Sent: Thursday, Novem
We make extensive use of full text searches, but have run into some problems
with backslashes. If a word like "somebody's" is entered into our database,
we escape the string using "mysql_escapes_string" in php. So,
mysql_escape_string("somebody's") becomes "somebody\'s" when it is saved in
the da