try
insert into pictures
values ('c:\\pictures\\computer.gif);
single \ is for escape special characters in MySQL.
-----Original Message-----
From: Roy Wasse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 4:42 PM
To: [EMAIL PROTECTED]
Subject: Link to pictures outside database
Hello MySQL fanatics,
My problem is the following:
I want to store a filelink in a table, but when I insert values into a
column of type varchar MySQL kills the slashes in the path.
EG
when i've created the following table:
create table pictures (
picturelink varchar(80) not null
);
insert into pictures
values ('c:\pictures\computer.gif);
mysql stores it as c:picturescomputer.gif
I think I'm making a basic mistake, I hope you guys can help me out!
grtz form Holland
---------------------------------------------------------------------
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
