Re: Special Character translation with export help needed

2005-11-08 Thread Boysenberry Payne
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,

Re: Special Character translation with export help needed

2005-11-08 Thread Boysenberry Payne
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,

Re: Special Character translation with export help needed

2005-11-08 Thread Boysenberry Payne
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: --

Re: Special Character translation with export help needed

2005-11-07 Thread Boysenberry Payne
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

re: special character

2002-11-13 Thread Victoria Reznichenko
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>

Re: Special Character \

2001-03-15 Thread Gerald L. Clark
<[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]&

Re: Special Character \

2001-03-15 Thread mysql
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

Re: Special Character \

2001-03-15 Thread Michail A.Baikov
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