how can i sort and reterive file path as string in mysql table?

Reply

Join Date: Oct 2008
Posts: 1
Reputation: davani is an unknown quantity at this point 
Solved Threads: 0
davani davani is offline Offline
Newbie Poster

how can i sort and reterive file path as string in mysql table?

 
0
  #1
Oct 25th, 2008
hi
i have problem when sorting file path like c:\test in mysql varchar field
it retrieve like c:test
what is my problem? what can i do to correct that
i am using vb.net so please help me
Reply With Quote Quick reply to this message  
Join Date: Dec 2007
Posts: 195
Reputation: mwasif is an unknown quantity at this point 
Solved Threads: 27
mwasif mwasif is offline Offline
Junior Poster

Re: how can i sort and reterive file path as string in mysql table?

 
0
  #2
Oct 26th, 2008
MySQL treat '\' as escape character. To save the exact path, you need to use c:\\test instead of c:\test.

For more details visit mysql manual.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the MySQL Forum


Views: 750 | Replies: 1
Thread Tools Search this Thread



Tag cloud for MySQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC