Is this the wrong list to ask this on?
If so can someone suggest a better list?
Am I missing something in my analysis of my problem?
Did I not include enough info?
Could it be a problem with perl scripts?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 8,
I figured out that it wasn't really the special characters that were
the issue, but the
addslashes function in php with the html tags. I just got rid of the
back slashes and all
is good. Sorry for the noise...
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov
I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�
View from table dump via phpMyAdmin export:
Habitat is a “what
I think the problem is mysqldump uses this:
DEFAULT CHARSET=latin1
with --set-charset
How can I get it to use utf8?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote:
I'm having difficulty getting certain special
Is there any means of running MySQL (3.23, mostly MyISAM tables running on
Win2k Server) so that escaped character sequences (those preceded by a
backslash \) are _not_ interpretted as anything other than literals? We're
trying to port a large number of web applications that previously used MS
Daya,
Wednesday, November 13, 2002, 7:51:53 AM, you wrote:
DKD Can naybody tell me how do i ignore special character while insering in
DKD mysql database. For example while i m inserting string 'dk\bd\r' it takes \b
DKD and \r as diffenrent character, although i can ignore it with one more
DKD
Hi,
Can naybody tell me how do i ignore special character while insering in
mysql database. For example while i m inserting string 'dk\bd\r' it takes \b
and \r as diffenrent character, although i can ignore it with one more
escape character like this 'dk\\bd\\r'. Field type is Text. Is there any
adam,
Friday, March 15, 2002, 9:47:03 PM, you wrote:
an I don't see how to submit 'blahblah;;' using the quotes.
an I've tried
an mysql -u root
an and then typed all the conceivable combinations for password
an and
an mysql -u root --password=blahblah;;
an and
an mysql -u root
I just had the brilliant idea of using a password for mysql root with
semi-colons:
password is blahblah;;
this appears to have not worked in some way and now I'm stuck. I don't
want to restart since that isn't very graceful (on a production
machine). I've tried blahblah;;; and blahblah and
with the client?
-Original Message-
From: adam nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: password special character muck up (I think)
I just had the brilliant idea of using a password for mysql root with
semi-colons:
password
I don't see how to submit 'blahblah;;' using the quotes.
I've tried
mysql -u root
and then typed all the conceivable combinations for password
and
mysql -u root --password=blahblah;;
and
mysql -u root --password='blahblah;;'
What's worse is that I've looked at the raw table file and
I can access the client using other users, but none have mysql database
access (ie. everything is fine except that I can't add users). If
nobody knows the answer, I will restart with skip-grant-tables during
off-hours.
-
1. If you can view blahblah;; in the password field of the user table, then the
password wasn't encoded in the
first place. That leads one to conclude the change was accomplished using UPDATE and
the field was set to
blahblah;; and not to PASSWORD('blahblah;;'). What mysql stores in the
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm
trying to insert and reselect
c:\My Documents into a varchar field and I keep having a problem with the special
character \
Jeff
use \\ combination
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 11:55 PM
Subject: Special Character \
Can someone tell me how to insert an selct back a directory into mysql using
sql? I'm trying to insert and reselect
c:\My
The problem with the \\ is that it inserts it into the database as \\ and
when it's retrieved it's a \\
- Original Message -
From: "Michail A.Baikov" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 2:08 PM
Subject: Re: Special Characte
16 matches
Mail list logo