|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
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
April 24th, 2000, 07:36 PM
|
|||
|
|||
|
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
April 24th, 2000, 10:04 PM
|
|||
|
|||
|
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 |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
