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
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>
<[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 and reselect
c:\My Docu