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 8,
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, 2005,
I tried using
`mysqldump $log -v -Q -c --set-charset --default-character-set=utf8
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick $db_name -r $bk_file 2>&1`
and I still get
-- MySQL dump 10.9
--
-- Host: localhostDatabase: --
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 ch
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 y
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 SQL
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 i
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 i
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 --password=
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 t
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.
-
Before
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 confi
able to connect
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-co
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 bla
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 2:08 PM
> Subject: Re: Special Character \
>
> > use \\ combination
> >
> >
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]&
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
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 a
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
18 matches
Mail list logo
