-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 characters
PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Monday, November 24, 2008 9:21 AM
Subject: RE: Special Characters
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 23, 2008 4:59 PM
To: MySQL List
Subject
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 or storage
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 = MyISAM CHARSET
-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 Description warnings
when loading a tab separated file
-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 Description warnings
when loading a tab separated file
PROTECTED]
To: 'C.R.Vegelin' [EMAIL PROTECTED]; mysql@lists.mysql.com
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, 2008 8:42 AM
To: mysql@lists.mysql.com
: 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 strange Data truncated for column
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 use Windows XP with MySQL
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
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 Schwartz [EMAIL PROTECTED]
wrote:
I am
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 seems
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 TABLE
-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 18, 2008 2:27 PM, Jerry Schwartz [EMAIL
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 into the MySQL command line
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 `giiexpr_db
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
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 mysql
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,
you could lose
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
Ballesteros Correa [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 that maybe
somebody can help me.
I use the ZEOS
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 with
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
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?
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 name
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.
You can write
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
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.
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
find the
@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
based, however the original database is on a Solaris box, and the
new server is RedHat.
The database has
, but as the representation of smart quotes isn't
standard you will.
-- 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
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
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:
?php
// some pre-form code
?
Form
?php
// some post-form
. As traffic increased
dramatically earlier this week, we had to grab another server, running
RedHat Fedora. We'll call her s006, and use to serve the webpages. All
happened very quickly and smooth for most of it. Only currently still
existing problem has (appearantly) to do with transferring the very special
. As traffic increased
dramatically earlier this week, we had to grab another server, running
RedHat Fedora. We'll call her s006, and use to serve the webpages. All
happened very quickly and smooth for most of it. Only currently still
existing problem has (appearantly) to do with transferring the very special
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 special characters.
Example
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
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? |
| fa |
| Fa |
| f? |
| F
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/
__ ___
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:
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
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 from an html form and there could be any
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 want
all
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 mysql. Ideas?
What
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's accessed
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
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 application and encountered a
small
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
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:
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
, 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 statement I dont know how I can put these as part
the string that I inserting
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 dont know how I can put these as part
the string that I inserting.
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 M
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 htmlspecialchars() function th
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 works fine except
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
Subject: special characters in MySQL query
I have written a pro
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
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
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 others
al 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 windows machine leaves "^M" character at the end
of each line of code. T
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 you can do
s 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 PROTECTED]
Sent: Tuesday, February 13, 2001 15:04
Subject: special characters messing me up
]
- 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
- Original Message -
From: "John W Ford" [EMAIL PR
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
followed
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 as
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 tr'
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
'//' two slashes
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 look for a file named
^M after the
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:
mv file file~ ; tr -d '\015' file~ 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-
: 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
I put it on
the Linux server.
That's a carriage return. DOS/Wi
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
73 matches
Mail list logo