SQLTeam.com | Weblogs | Forums

How to retrieve same string saved from SQL database on Linux server?

sql2014

#1

Hello friends,

I have an issue with fetching inserted data from database. I have inserted a string CENTRALIZER,MOTOR 5.50" OD 3SS into database in PHP But when i try to fetch it from database on Linux server. It showing result like as:-
CENTRALIZER,MOTOR 5.50" OD 3SS i.e. not same as above.

Please help how to fix to fix this issue online on Linux server.

You can use " in any string & insert it into database. But when you fetch it, got wrong results online on server. But it works correctly on my localhost.


#2

due to the escape character \ is showing in the result. this result because of double quote.


#3

Note that this is a SQL Server forum. SQL Server does not run on Linux