set up for the single quote issue

Anon

In one of my interbase server set up, if in SQL statment, there is single quote " ' " in the values, i will get sql error. But in another interbase server, the single quote in the sql statment values will not cause the problem.

It is because the set up of interbase? or set up of php?

Both of them are on a platform php/interbase.

thanks

Hui

bretticus

values meaning...

insert into table () values ()???

When you come accross a single quote that's not a delimiter for the value, you need to escape it:

'value\'s'

I have not worked with interbase before and I'm not completely sure I understand your question. But I'm fairly certain that you need to escape any single quotes within single quotes.

For MSSQL you use another single quote:

'value''s'

Anon

thanks,

say

$comanyname="sunshine's web develop";

$sqladdcategory="INSERT INTO TABLE1 (companyname) VALUES ('$companyname')"

i have to use
$companyname=str_replace("'", "''", $companyname); to get rid off the sigle quote.

it is working fine.

but when i install it on another server.

the companyname value in the database become "sunshine''s web develop". and on that server

i DON'T have to use
$companyname=str_replace("'", "''", $companyname); to get rid off the sigle quote.

if i comment out the statement
//$companyname=str_replace("'", "''", $companyname);

then the value in the database will be fine as it is supposed to be, "sunshine's web develop".

these two servers are both php/interbase. so i guess it is set up of interbase differently. that one set up i have to handle the single quote issue, one set up i don't.

but i checked them out, didn't find the set up difference beween these two servers.

hui