|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Hello,
I am creating a table with one of the fields being of type VARCHAR (50). I am using LOAD DATA INFILE to import the data. Is it ok for the VARCHAR field to have a value like this: "Bob's Place" with the '? If not, how would I add it? Thanks! yoshi http://www.datera.com [This message has been edited by yoshi (edited April 24, 2000).] |
|
#2
|
|||
|
|||
|
Should be OK to leave ' as is if you're using LOAD DATA INFILE
Otherwise, if you're processing form data, you can use $text=addslashes($text); in a PHP script |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Adding ' to a text field? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|