z" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Monday, November 24, 2008 9:21 AM
Subject: RE: Special Characters
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent
>-Original Message-
>From: Mike Blezien [mailto:[EMAIL PROTECTED]
>Sent: Sunday, November 23, 2008 4:59 PM
>To: MySQL List
>Subject: Special Characters
>
>Hello,
>
>we are in the process of setting up a database with members data and
>other info.
>We'll need to enter names with special ch
Asad Habib <[EMAIL PROTECTED]> wrote on 02/11/2005 04:03:32 PM:
> Does anyone know where I can find a list of characters that cannot be
> inserted into a MySQL database as part of a string? I know that MySQL
does
> not accept single and double quotes and that these have to replaced by
> their nam
Try mysql_escape_string instead of addslashes.
Also, I'm not sure why you did it, but you don't need to include your entire
form in the PHP script and echo it. If you have PHP code before and after
the form, you could use this approach:
Form
You could also try escaping the title all of the
Hi Chris,
You're fine with mysql_real_escape_string(). % or _ only need to be
escaped if you're using them in LIKE and want them to match
iterally. -- never needs to be escaped in a string.
BTW, if you're using PHP and the stupid magic_quotes_gpc is on, you
don't want to escape stuff yourself a
At 5:30 PM -0500 3/23/01, Lee Jenkins wrote:
>I apologize because I know I've seen this somewhere on the list before
>(should have saved it). I'm trying to insert some data into CHAR fields
>that have trailing Ascii 0 characters, but get a syntax error.
>
>The data would like this:
>
>23302220202
Rolf Hopkins ([EMAIL PROTECTED]) writes:
> I think you mean addslashes()
> > If you are using PHP there is the htmlspecialchars() function that will do
> just that for you.
> > > > > I have written a program which reads data from WWW forms and passes
> > > > it to
> > > > > MySQL queries. All w
I think you mean addslashes()
- Original Message -
From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 2:37
Subject: Re: special characters in MySQL query
> If you are using PHP there is the htmlspecialc
If you are using PHP there is the htmlspecialchars() function that will do just that
for you.
cheers,
thalis
> > - Original Message -
> > From: "Robert Heron" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, February 17, 2001 6:35 PM
> > Subject: special characters in
ay, February 18, 2001 0:18
Subject: Re: special characters in MySQL query
> No, solve it in your own program.
>
>
> - Original Message -
> From: "Robert Heron" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, February 17, 2001 6:35 PM
&g
No, solve it in your own program.
- Original Message -
From: "Robert Heron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 6:35 PM
Subject: special characters in MySQL query
> I have written a program which reads data from WWW forms and passes
it to
> MyS
d; Mysql
> Subject: Re: special characters messing me up
>
>
> At 23:04 12-02-2001 -0800, John W Ford wrote:
> >I can't figure out why my windows machine leaves "^M" character
> at the end
> >of each line of code. This causes the file to be messed up when
>
mv file file~ ; tr -d '\015' file ; rm file~
Or, in vim, :set fileformat=unix
Or, use PFE32.EXE on Windows as your editor (allows saving
as Unix text file).
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From
John
Here is another solution to removing those '^M'
chars. This is a lot simpler
than my last idea :-
sed 's/^M//g' YOUR_FILE > YOUR_NEW_FILE
Michael Thomas
www.abcXyz.com
>
-
> Before posting, please check:
>http://www.
Try this,
The code below will remove the last character from
each record in your file. On your Linux system
enter this line on the command line and the
results will appear in the NEW_FILE. Obviously you
can name the input and output files anything you
want.
awk '{print substr($0, 1, length-1)}'
> > Or a handy one-liner...
> >
> > perl -pi -e "s/[\012\015]//" *.sql
> >
> >
>
> Or alternatively edit the file with vi and do:
> :s///
>
> This inteprets to the following keystrokes:
> ':' colon
> 's' s for substitute
> ''Ctrl-v-m to create the annoying ^M as one character
> '//'
On Tue, 13 Feb 2001, Irmund Thum wrote:
> Rolf Hopkins schrieb:
> >
> > "^M"???
The ^M is the carriage return/line feed usually found in ms/dos text
files.
On my Linux system (on downloaded files) I removed them by
tr -d \r old file > new file.
tr = text replace; -d delete; \r = ^M
see 'info
On Tue, 13 Feb 2001, Peter Skipworth wrote:
> Or a handy one-liner...
>
> perl -pi -e "s/[\012\015]//" *.sql
>
>
Or alternatively edit the file with vi and do:
:s/
//
This inteprets to the following keystrokes:
':' colon
's' s for substitute
'
' Ctrl-v-m to create the annoying ^M
"M" is the thirteenth letter of the alphabet. ASCII 13 (^M) is the
carriage return. If you are using binary transfer on ftp, then you
will get these and any other control characters imbedded in your
file. Set your ftp to ASCII and try again. Perl is particulary
sensitive to this. HTML doesn't
;
> Cc: "Mysql" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 13, 2001 7:31 AM
> Subject: Re: special characters messing me up
> > >>
> > >> - Original Message -
> > >> From: "John W Ford" <[EMAIL PROTECTED]>
> &
At 23:04 12-02-2001 -0800, John W Ford wrote:
>I can't figure out why my windows machine leaves "^M" character at the end
>of each line of code. This causes the file to be messed up when I put it on
>the Linux server.
That's a carriage return. DOS/Windows ends a line with a carriage return
follow
PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Irmund Thum" <[EMAIL PROTECTED]>
Cc: "Mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 7:31 AM
Subject: Re: special characters messing me up
> >>
> >> -
can you please stop sending attachments through the list?
At 11:24 AM +0100 2/13/01, Irmund Thum wrote:
>Rolf Hopkins schrieb:
>>
>> "^M"??? You sure it is that? Anyway, it is most likely to do with carriage
>> returns. Windows uses CR and LF to indicate a new line, while Linux and
>> Macs
On Tue, 13 Feb 2001, Irmund Thum wrote:
> Rolf Hopkins schrieb:
> >
> > "^M"??? You sure it is that? Anyway, it is most likely to do with carriage
> > returns. Windows uses CR and LF to indicate a new line, while Linux and
> > Macs only use LF. Hopefully this will help. Don't know what yo
Rolf Hopkins schrieb:
>
> "^M"??? You sure it is that? Anyway, it is most likely to do with carriage
> returns. Windows uses CR and LF to indicate a new line, while Linux and
> Macs only use LF. Hopefully this will help. Don't know what you can do
> about it though.
>
> - Original Messa
"^M"??? You sure it is that? Anyway, it is most likely to do with carriage
returns. Windows uses CR and LF to indicate a new line, while Linux and
Macs only use LF. Hopefully this will help. Don't know what you can do
about it though.
- Original Message -
From: "John W Ford" <[EMAIL
26 matches
Mail list logo
