17 messages in com.mysql.lists.mysqlRe: special characters messing me up
FromSent OnAttachments
John W Ford12 Feb 2001 23:03 
Rolf Hopkins12 Feb 2001 23:33 
Irmund Thum13 Feb 2001 02:24 
clay bond13 Feb 2001 03:23 
tlr7...@garnet.acns.fsu.edu13 Feb 2001 04:31 
Pat Sherrill13 Feb 2001 05:24 
G. Adam Stanislav13 Feb 2001 06:35 
The Tilghman13 Feb 2001 06:46 
Peter Skipworth13 Feb 2001 06:50 
John Jensen13 Feb 2001 09:08 
Thalis A. Kalfigopoulos13 Feb 2001 09:38 
Peter Lewis13 Feb 2001 10:06 
Thalis A. Kalfigopoulos13 Feb 2001 11:10 
John W Ford13 Feb 2001 12:04 
mike thomas13 Feb 2001 14:13 
mike thomas13 Feb 2001 14:26 
Peter Lewis14 Feb 2001 12:11 
Subject:Re: special characters messing me up
From:Peter Skipworth (sk@peterskipworth.com)
Date:02/13/2001 06:50:16 AM
List:com.mysql.lists.mysql

Or a handy one-liner...

perl -pi -e "s/[\012\015]//" *.sql

On Tue, 13 Feb 2001, Pat Sherrill wrote:

When ftp'ing the file use the ASCII mode instead of the BINARY mode. All CR/LF conversions will take place automagically. Alternatively some linux distributions have a utility to strip CR's from ASCII files and there is always old reliable vi .

I hope this helps... Pat... patr@coconet.com

----- Original Message ----- From: <tlr7@garnet.acns.fsu.edu> To: "Irmund Thum" <thu@web.de> Cc: "Mysql" <mys@lists.mysql.com> Sent: Tuesday, February 13, 2001 7:31 AM Subject: Re: special characters messing me up

----- Original Message ----- From: "John W Ford" <john@wvi.com> To: "Mysql" <mys@lists.mysql.com> Sent: Tuesday, February 13, 2001 15:04 Subject: special characters messing me up

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.

It makes my perl interpreter look for a file named ^M after the very first line.

#!/usr/sbin/perl

also... what else I can't figure out is why this special character is sometimes hidden and sometimes visible in my Emacs program in

Linux...

this

is the program I used in which I found the problem.

anybody know?

John Ford

this is a very old well-known Windows issue; you should use a text editor what can save your files in UNIX format: I guess every professinal editor has this option, see Textpad or Dreamweaver...

-- http://it97.dyn.dhs.org/ Irmund Thum +49 179 6998564 +49 6374 992541 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Disposition: attachment; filename="smime.p7s" Content-Description: Kryptographische Unterschrift mit S/MIME

Attachment converted: Ionia:smime.p7s (????/----) (00013E6A)

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-patrick=coco@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail
<mysql-unsubscribe-skip=pete@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php