Database fetch row containing an Ampersand character truncates the return string

Question

Problem: sql = select address from mytable were name like 'T%' returns address ok except where the address is like 'Cr James & Dennis Street'. This value is returned truncated to 'Cr James'

My database is a mssql server. I use the PHP ODBC driver with the following connection string:

$db = odbc_pconnect("Driver={SQL Server Native Client 10.0};
Server=" . $SERVER . ";Database=". $Database. ";", $UID, $PWD);

can you show us the code where you are outputting the address in PHP? thank you! — low_rents, Jul 29 '15 at 07:15

score -1 · Answer 1 · edited May 23 '17 at 10:24

-1

In mysql we can use mysqli_real_escape_string like:

mysql_query('SELECT * FROM table WHERE column like "%'.mysqli_real_escape_string("data & the base").'%"');

Read this post, perhaps it helps you:

mysql_real_escape_string alternative for SQL Server

edited May 23 '17 at 10:24

Community

1
1

answered Jul 29 '15 at 07:33

Javi

506
3
15

OP is talking about the return value: "(...) returns address ok except (...)" – low_rents Jul 29 '15 at 07:35
Yes, the problem is '&' character, so, exclude and search Cr James Dennis Street instead Cr James & Dennis Street – Javi Jul 29 '15 at 07:36
and why should this change the returned value? – low_rents Jul 29 '15 at 09:11

Database fetch row containing an Ampersand character truncates the return string

1 Answers1