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&#x
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 characters, i.e:
apostrophes: O'Rourke
tildes: Magglio Ordóñez
titlo: Anaïs
hyphen: Chun-Myers
Is there some special table setup required, collation
This isn't really a problem with MySQL; MySQL just trips on it.
Let me caution you that this discussion applies to Windows. I did observe
this in my applications on Linux, but the problem will show itself only when
reading a file, whether uploaded or not; there will be no problem if the
data is en
ubject: Re: data truncation warnings by special characters
I have some php code I use to import data that is a bit more flexible and
robust than the load data statement in MySQL If you use php I can share
the code with you.
C.R.Vegelin wrote:
Hi Jerry,
Sorry, I should have mentioned that I
, April 18, 2008 2:30 PM
Subject: RE: data truncation warnings by special characters
>-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get s
t; <[EMAIL PROTECTED]>
To: "'C.R.Vegelin'" <[EMAIL PROTECTED]>;
Sent: Friday, April 18, 2008 2:30 PM
Subject: RE: data truncation warnings by special characters
>-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2
>-Original Message-
>From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@lists.mysql.com
>Subject: data truncation warnings by special characters
>
>Hi List,
>
>I get strange "Data truncated for column Descripti
>-Original Message-
>From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@lists.mysql.com
>Subject: data truncation warnings by special characters
>
>Hi List,
>
>I get strange "Data truncated for column Descripti
Hi List,
I get strange "Data truncated for column Description" warnings
when loading a tab separated file with special characters.
The definition of the target table is:
CREATE TEMPORARY TABLE tmp
( Code CHAR(8) NOT NULL,
Description TEXT NOT NULL,
KEY Code (Code)
) ENGINE = MyIS
> use UTF-8 for text files
> use SET NAMEs to correctly MySQL what charset you are using
>
>
>
> --
> Sebastian
[JS] You are correct. The results were very confusing, especially since the
visual difference between a hyphen (0x2D) and an N-quad (0x96). Also,
copying UTF-8 text to a command window s
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan 18, 2008 2:27 PM, Jerry Schwar
Jerry Schwartz schrieb:
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan
Jerry,
On Jan 18, 2008 2:27 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> I am having trouble inserting special characters into a table. I am using
> the MySQL client. I put the following commands into a text file (I'm on
> WinXP, using Notepad), copy them, and paste them in
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY TABLE `giiex
Hello.
What do you think about switching to mysqldump with --hex-blob
option?
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Restoring a backup of a very large database, I've received an error
> message by the server (4.13) about an sql syntax error. I've done the
> backup with my
Restoring a backup of a very large database, I've received an error
message by the server (4.13) about an sql syntax error. I've done the
backup with mysql administrator and I've used the same procedure for
months without problems.
I've discovered that problem is into a blob
field that store lo
Hello.
I see nothing wrong in your settings. The problem could be that
special characters in windows have different codes than in latin1,
as was mentioned by Dusan Pavlica. When you'll debug this issue
try to keep the table's and column's encoding the same as in SET NAMES,
Hi, Mr. Paharenko,
Here are the results:
character_set_client | latin1
character_set_connection | latin1
character_set_database | latin1
character_set_results| latin1
character_set_server | latin1
character_set_system | utf8
character_sets_dir | C:\Archivos de
programa\My
Hello.
What output do these statements produce:
show variables like '%char%';
show variables like '%coll%';
Include the results of SHOW CREATE TABLE
executed on your tables as well.
Javier Ballesteros Correa <[EMAIL PROTECTED]> wrote:
> Hi, everybody!
> I have a problem working wit
Dusan
- Original Message -
From: "Javier Ballesteros Correa" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 10, 2005 1:14 PM
Subject: inserting special characters
Hi, everybody!
I have a problem working with MySQL and C++ Builder 6.
I can´t find the solution and I hope tha
Hi, everybody!
I have a problem working with MySQL and C++ Builder 6.
I can´t find the solution and I hope that maybe
somebody can help me.
I use the ZEOS components (6.1.5) to connect the MySQL
database (version 4.1.11) with C++ Builder. The fact
is that everything goes rigth except when I try to
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
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 name code equivalents. Are there any other characters that are
unacceptable?
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull <[EMAIL PROTECTED]> wrote:
> That is what I was wondering, but not sure how to check/set the proper
> character set.
>
> Thanks.
>
> -Andy
>
> Quoting Gleb Paharenko <[EMAIL PROTECTED]>:
>
>> Hello.
>>
ll <[EMAIL PROTECTED]>
> > > To: mysql@lists.mysql.com
> > > Date: Tuesday, January 04, 2005 10:19:20 AM -0500
> > > Subject: Embedded Quotes and Special Characters.
> > >
> > > I'm moving a database from one server to another. Both are unix
- Original Message --
> > From: Andrew Mull <[EMAIL PROTECTED]>
> > To: mysql@lists.mysql.com
> > Date: Tuesday, January 04, 2005 10:19:20 AM -0500
> > Subject: Embedded Quotes and Special Characters.
> >
> > I'm moving a database from one server
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko <[EMAIL PROTECTED]>:
> Hello.
>
> You can write a script which will walk through all tables and
> update the rows using replace() function. But, I think, you should
> fin
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong character
set.
I'm moving a database from one server to another. Both are unix based,
however the original database is on a Solaris box, and the new server is
RedHat.
The database has embedded "s and 's in some of the varchar fields. When I
moved the database, I did a mysqldump, copied the text file to the
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
Newbie type question:
apostrophes ie. a ' single quote is not "getting into" the database
fields. So if I entererd in a PHP/MYSQL web page entry field: Sally's
Website. When I look directly into the column with the MYSQL cmdline I
see: Sally s Website. Below are the code snips I'm using(I number
y) to do with transferring the very special
characters over the lines between s007 and s006, displaying them on the
screen and entering them in the database through webforms. Normal special
chars like é, ê, à and so on seem to be displayed ok (after calling
htmlentities in php: PHP 4.3.3 (cgi) (built
y) to do with transferring the very special
characters over the lines between s007 and s006, displaying them on the
screen and entering them in the database through webforms. Normal special
chars like é, ê, à and so on seem to be displayed ok (after calling
htmlentities in php: PHP 4.3.3 (cgi) (built
I've solved the problem starting the server using the
option --character-set=dos.
The side effect is that searches become
accent-sensitive.
Best wishes.
--- Ricardo <[EMAIL PROTECTED]> escreveu: > I have a
problem with SELECT DISTINCT if the target
> field contains s
But I think the collation set only applies to MySQL
4.1, doesn't it? I'm using MySQL 4.0.16.
I found no "character_set_server" system variable.
Only "character_set".
http://dev.mysql.com/doc/mysql/en/Charset-map.html
Thanks.
--- Jochem van Dieten <[EMAIL PROTECTED]>
escreveu: > Ricardo wrote:
latin1
>--- Egor Egorov <[EMAIL PROTECTED]> escreveu:
> What is the character set of the data? What is the
> character set of MySQL server?
>
>
>
> --
> For technical support contracts, goto
> https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net
> http://www.ensita.net/
Ricardo <[EMAIL PROTECTED]> wrote:
> I have a problem with SELECT DISTINCT if the target
> field contains special characters.
>
> Example:
>
> select MyField from MyTable
> +--+
> | MyField |
> +--+
> | f? |
> | F?
I have a problem with SELECT DISTINCT if the target
field contains special characters.
Example:
select MyField from MyTable
+--+
| MyField |
+--+
| fá |
| Fá |
| fa |
| Fa |
| fâ |
| Fâ |
| fã |
| Fã |
+--+
select
Hello all.
Any help on the following matter is greatly
appreciated. I tried to import a text file
containing numerous special characters (À, Æ, Ç ,
etc.) but they convert to incorrect characters.
I can paste them and write them correctly using a
form submission created with LP6. However
scape stuff yourself again, or it will add too many
slashes! So you need to check for that somehow.
Hope that helps.
Matt
- Original Message -
From: "Chris W"
Sent: Wednesday, December 31, 2003 4:44 PM
Subject: special characters as field values
> I am storing data fro
I am storing data from an html form and there could be any character in
there, including a % and an _. I'm using mysql_real_escape_string in
php to escape special characters, but it says it doesn't escape the %
and _. I was also reading something about escaping the -- . If I wa
lem or knows how to write a sql statement using a
different function that handles special characters like apostrophe's, it would be
GREATLY appreciated. I am using
AY> asp on a w2k server platform. To run the statement, i've tried going through
adodb, mysqlgui, and just plain mysq
that handles special characters like
apostrophe's, it would be GREATLY appreciated. I am using asp on a w2k server
platform. To run the statement, i've tried going through adodb, mysqlgui, and just
plain mysql. Ideas?
Adam
There have been a lot of questions here about how to store,
sort, etc. various special characters and alphabets in
MySQL internally. Maybe this isn't really a MySQL question,
but I'd like to know how to deal with such characters over
a Web interface.
I have a database of books that&
Please RTFM
http://www.mysql.com/doc/S/t/String_syntax.html
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 18:12
Subject: Input of special characters!
> Hi!
>
> I have started to write a small web based applicat
Hi!
I have started to write a small web based application and encountered a
small problem.
If I use any of escape characters in the web based forms like the singel
quote ' the value of that field
will not be inserted in the database.
I know that a singel quote can be written like '' to be able
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
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:
23302220202X
Where "X" represents the
At 1:24 AM + 2/21/01, [EMAIL PROTECTED] wrote:
>Dear Sirs :
>
>Please I would want to konw How I can insert special
>characters into a table,
>
>Since the " and ' chars are used for delimiting values into
>an insert statement I don¥t know how I can put t
ED]>
Sent: Wednesday, February 21, 2001 9:24
Subject: inserting special characters
> Dear Sirs :
>
> Please I would want to konw How I can insert special
> characters into a table,
>
> Since the " and ' chars are used for delimiting values into
> an insert statem
Dear Sirs :
Please I would want to konw How I can insert special
characters into a table,
Since the " and ' chars are used for delimiting values into
an insert statement I don´t know how I can put these as part
the string that I inserting.
I got this putting the data into a file
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
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 W
I have written a program which reads data from WWW forms and passes it to
MySQL queries. All works fine except for the cases when the form is filled
with characters like '%', '"', ''', etc. Then, these characters are treated
like special, formatting characters in SQL query, which, of course demage
Hello List,
I mentioned that I'd fixed my problem with the special characters. Everybody
had some great tips... I like to use Adobe Go Live to design web pages and
it has a text editor that leaves file in the right format... so I just used
it to save the files. If you use NOTEPAD or many o
On Tue, 13 Feb 2001, John W Ford wrote:
> Thanks everybody for helping me out... I got the scripts loaded and am
> talking to mySQL via DBI now.
>
Good John,
Which method did you use?
Please let us know so we can add it to our list of fixes ...
Regards
Peter
[EMAIL PROTECTED]
--
It is as sp
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.
day, February 12, 2001 11:04 PM
To: Mysql
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 lo
> > 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
> >>
> >> -
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 PROTECTED]>
>> To: "Mysql" <[EMAIL
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
it though.
>
> - Original Message -
> From: "John W Ford" <[EMAIL PROTECTED]>
> To: "Mysql" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 13, 2001 15:04
> Subject: special characters messing me up
>
> > I can't figure out why my w
John W Ford" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
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 cod
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 fi
77 matches
Mail list logo
