double quotes in varchar
Posted: Thu Jul 28, 2005 3:41 am
Hi,
I have a set of data transferred from a csv to a db table.
The data goes into the varchar field fine when converted but when i manipulate the data to store it into a relational table using php i get any string which is like:
" hello
a double quote without end double quotes stored as
"
hello
in a varchar field in mysql, which is strange
when i insert into a db table i use the following to store the data to a string:
<?php
$stu_alt_tel = mysql_escape_string($EMERGENCY);
?>
any ideas how i can put any string no matter what format on one line and escape any kinds of problems?
I have a set of data transferred from a csv to a db table.
The data goes into the varchar field fine when converted but when i manipulate the data to store it into a relational table using php i get any string which is like:
" hello
a double quote without end double quotes stored as
"
hello
in a varchar field in mysql, which is strange
when i insert into a db table i use the following to store the data to a string:
<?php
$stu_alt_tel = mysql_escape_string($EMERGENCY);
?>
any ideas how i can put any string no matter what format on one line and escape any kinds of problems?