data type for storing a filename string

[jnash]

im trying to get this value into my db (mySQL)

c:\Documents and Settings\halo9\My Documents\Visual Studio 2005\Projects\SuperVids\SuperVids\bin\CustomerPics\Al10 111.jpg

ive tried setting it as type text in the table designer but it stores it as

Cocuments and Settingshalo9My DocumentsVisual Studio 2005ProjectsSuperVidsSuperVidsinCustomerPicsJOI.jpg

any one help me out as i need to reproduce this to show a file path and it comes out garbled!

thanks alot


Jon

 

[TechGnome]

In MySQL, the \ is used as an escape char.... in order to get a \ in there is to double up the \ so that you have \\.
c:\\Documents and Settings\\halo9\\My Documents\\Visual Studio 2005\\Projects\\SuperVids\\SuperVids\\bin\\CustomerPics \\Al10 111.jpg


-tg

 

[jnash]

thank you so much , now sorted!