On Sun, Apr 08, 2001 at 10:34:17PM -0600, Jack A. Tinsley Jr. wrote:
>
> First, things, first - I am a newbie to MySQL but I have it up and
> running quite well. The only thing I haven't been able to figure
> out is why I'm losing "\" (back slashes) in my stored data. I have
> a application I'm considering MySQL for and one table must have a
> column containing a UNC path. When I insert the value of
> "\\server\folder", MySQL turns it into "\serverfolder" - very
> strange. I've set this column up as a varchar.
The "\" character is an escape character, often used to include
otherwise "special" characters in your data. To include a literal "\"
in your data, you need to actually double it up "\\".
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php