> -Original Message-
> 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
data 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)
ot;
I will see 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
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 re
"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?
Ab
> 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 opti
k you just need 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
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 sug
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
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 PR
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 in as \&#x
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&#
The
problem comes 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
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
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 e
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 MESSA
msg.pgp
Description: PGP message
date),
KEY priority (priority),
KEY facility (facility)
) TYPE=MyISAM;
This is how I am piping the log into the database
mysql -u root --password=passwd syslog < /tmp/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
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 erro
msg.pgp
Description: PGP message
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 Nels
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&#
s.html
* http://www.mysql.com/doc/en/Out_of_memory.html
* http://www.mysql.com/doc/en/Error_handling.html
* http://www.mysql.com/doc/en/Check.html
This was an automated response to your email 'AW: apostrophe and comma error on
submit'.
Final search keyword used to query
ERT statements.
It's also in the manual, 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 abou
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.
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
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 for
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 =
>
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
t;René Tegel" <[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: &qu
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; "Eric Fitzgerald"
<[EMAIL PROTECTED]>; "Randy Johnson" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday,
<[EMAIL PROTECTED]>; "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. Yo
ssage -
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.
y php 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
;
- Original Message -
From: "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?
>
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 inst
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.ph
38 matches
Mail list logo
