above the sentence as Halid ''s car is expensive on web
(internet explorer)
That is, I see that double ' apostrophe character out
What shall I do ?
Thanks
with phpadmin on web. it works well. But I have a
problem.
As example if I add a text to mysql table with phpadmin.
My text contains as below;
Halid 's car is expensive
I will see above the sentence as Halid ''s car is expensive on web
(internet explorer)
That is, I see that double ' apostrophe
-
From: Halid Faith [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 11:51 AM
To: mysql@lists.mysql.com
Subject: apostrophe char problem
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and
apache-2.0.53 on
FreeBSD5.3
I add any text as data with phpadmin on web
to
change 1 line in myisam/ftdefs.h:
#define misc_word_char(X) ((X)=='\'')
change that to:
#define misc_word_char(X) (0)
I HOPE that is correct! ;-)
Matt
- Original Message -
From: Andrea Gangini
Sent: Thursday, June 10, 2004 9:44 AM
Subject: Help with apostrophe and FTS
The ' isn't NOT a stopword, it's simply not a word-boundary character,
which I think is what you want.
Yes, I expressed myself badly, but you have just greatly understood my
problem.
change that in MySQL... unless you edit the source of course and
compile it yourself. :-) Is that an option
Andrea Gangini [EMAIL PROTECTED] wrote:
Well yes, it's an option. I really need this functionality.
But on mysql site, under source downloads, there's this warning: For
maximum stability and performance, we recommend that you use the binaries we
provide.
Is it really true?
Absolutely.
On Fri, Jun 11, 2004 at 03:34:14PM +0300, Egor Egorov wrote:
Andrea Gangini [EMAIL PROTECTED] wrote:
Well yes, it's an option. I really need this functionality. But
on mysql site, under source downloads, there's this warning: For
maximum stability and performance, we recommend that
Is there the possibility of making the apostrophe char ( ' ) a stopword in
mysql?
Full text search queries in italian or other European language are greatly
affected by that; for example searching amore will not return dell'amore
as a match
Any workaround suggested?
Andrea Gangini [EMAIL
I usually use php for most of my work, but I have to run a fair percentage
of maintenance etc from the mysql shell program. I have a record that has
an apostrophe and so was inserted using php by escaping the ' with \ so that
it was put in as \' and it shows up in the record as O'Brien
At 14:25 -0500 2/25/04, Larry Brown wrote:
I usually use php for most of my work, but I have to run a fair percentage
of maintenance etc from the mysql shell program. I have a record that has
an apostrophe and so was inserted using php by escaping the ' with \ so that
it was put
Are you not able to do
SELECT *
FROM table
WHERE col = O\'Brien
?
Original Message
On 2/25/04, 1:25:06 PM, Larry Brown [EMAIL PROTECTED]
wrote regarding command line escape for apostrophe:
I usually use php for most of my work, but I have to run a fair
percentage
of maintenance etc
My bad people. The error was elsewhere in the query, but the error
happenned to describe the query as failing near where the apostrophe was.
Sorry to waste anyone's time.
Larry
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 2:25 PM
Try using QUOTE function.
Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax
Man I have been banging away at this for a week and I am only just
getting to a point where I am finding a resolution. There seems to be a
lot of info out there for this kind of thing, but very little on how to
implement it.
I use ASP and VBScript with Macromedia Dreamweaver so with asp I can
when you are talking to mysql: the apostrophe (single
quote) delimits the start and end of a string. So, the following won't
work:
INSERT INTO sometable (name) VALUES ('Paul O'Brien');
This is because the single quote (apostrophe) in the middle ends the
string, leaving syntactic garbage after
msg.pgp
Description: PGP message
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax
msg.pgp
Description: PGP message
/mysql.pipe
It was working fine until it saw a apostrophe in the log and then failed
to insert
I am using mysql Ver 12.22 Distrib 4.0.17, for sun-solaris2.7 (sparc)
Basically syslog-ng does exactly what it suppose to do. collect the logs
from the source and send it to the destination which is happened
msg.pgp
Description: PGP message
At 22:30 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Message -
From: Bryant Hester [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 07, 2003 6:48 AM
Subject: RE: apostrophe and comma error on submit
You need to delimit them:
INSERT INTO table VALUES ('value','Don\'t know','');
If you're inserting via
In the last episode (Feb 07), [EMAIL PROTECTED] said:
Hi Rusch (ext) Reiner [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
Can we maybe block [EMAIL PROTECTED] emails to the list?
--
Dan Nelson
, somewhere
HTH,
Bryant Hester
Mysql, query
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit
Does anyone know about an error that occurs when you try to submit
escape your data with a black slash
\' if you mean to have a literal single quotation mark.
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit
Does anyone know about
Hi,
Does anyone know about an error that occurs when you try to
submit into mysql.
Whever i try to imput any text with a comma in it or an
appostrophe, i get an error until i remove it.
Any suggestions. .. anyone...? Im using php and submiting
via post, when i get the error.
Thank
Does anyone know about an error that occurs when you try to submit into mysql.
Whever i try to imput any text with a comma in it or an appostrophe, i get an error
until i remove it.
Any suggestions. .. anyone...? Im using php and submiting via post, when i get the
error.
Thank you so much
Hi,
I am having bother trying to perform a select, that has an apostrophe in
the value Im looking for. Below is the Perl code Im using.
$SQLStatement = SELECT ID FROM Albums WHERE Name =
'.$DBHandle-quote($Name).';;
$STLookUpHandle=$DBHandle-prepare($SQLStatement
On Wed, 24 Oct 2001, John Abel wrote:
Hi,
I am having bother trying to perform a select, that has an apostrophe in
the value Im looking for. Below is the Perl code Im using.
$SQLStatement = SELECT ID FROM Albums WHERE Name =
'.$DBHandle-quote($Name).';;
$STLookUpHandle
D]; "Eric Fitzgerald" [EMAIL PROTECTED];
"Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 1:27 AM
Subject: Re: apostrophe
Or you can fix your php by turning off the magic_quotes_gpc flag. You
then
won't need to change your code.
- Original Message -
From: "Ren Tegel" [EMAIL PROTECTED]
To: "Rolf Hopkins" [EMAIL PROTECTED]; "Eric Fitzgerald"
[EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 18:48
Subject: Re: a
" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED];
"Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 12:40 AM
Subject: Re: apostrophe
- Original Message -
From: "Ren Tegel" [EMAIL PROTECTED]
To: "
When a text with an apostrophe in it has a \' in it. How can I fix this?
example
randy's is stored in the DB as randy\'s
thanks
Randy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Randy Johnson wrote:
When a text with an apostrophe in it has a \' in it. How can I fix this?
example
randy's is stored in the DB as randy\'s
thanks
Randy
If you just want to fix that one instance just do
update tablename set columname = 'randy\'s' where somekey
Randy Johnson" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 9:54 AM
Subject: apostrophe
When a text with an apostrophe in it has a \' in it. How can I fix this?
example
randy's is stored in the DB as randy\'s
than
seems to have loads of undocumented - and worse, changing,
behaviour.
regards,
rene
- Original Message -
From: "Eric Fitzgerald" [EMAIL PROTECTED]
To: "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 7:15 PM
Subject: Re: apostroph
-
From: "Ren Tegel" [EMAIL PROTECTED]
To: "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson"
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 2:56
Subject: Re: apostrophe
this was true on php 4.01 but not on php 4.04pl1, i have to escape m
37 matches
Mail list logo
