RE: Backslash and full text searches

2003-11-17 Thread Jason Ramsey
knows there's a character there, it just won't allow you to escape the "\" to be able to use it. I'm going to do a configuration comparison for both php and mysql between the two boxes and try to hunt down the problem. -Original Message----- From: Matt W [mailto:[EMAIL P

RE: Backslash and full text searches

2003-11-13 Thread Jason Ramsey
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'

Backslash and full text searches

2003-11-13 Thread Jason Ramsey
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

Format of stopwords file

2003-11-13 Thread Jason Ramsey
In the docs is says that you can define your own stopwords file for fulltext searching. The following is under show variables... ft_stopword_file The file from which to read the list of stopwords for full-text searches. All the words from the file will be used; comments are not honored. By defaul

runnaway mysql children processes

2003-09-02 Thread Jason Ramsey
Hey everyone, I'd appreciate it if anyone on this list might be able to help us out with a problem we've been having with mysql lately. We are using mysql as a backend for a content management system on our site. We've been using it for awhile, and it has been working fine. However, we recently