Save formula postgresql

Question

Save formula postgresql

Navigation

#1 by (1 votes)

1

I have the following query

UPDATE teste SET
    equacao = 'X*254/1024+15.2', 
    zerar = False, 
    MinValid = 0.00 
WHERE id = 1 
RETURNING *

It runs normally, but when I get to the database the plus + sign disappears: X*254/1024 15.2 .

How do I change the query so that the plus sign is saved as a character?

postgresql

asked by anonymous 15.02.2018 / 20:54

1 answer

Wrong date format in xamarin forms, how to solve? How to check if user has already been registered in the database?

score 1 · Answer 1

The problem was not in pgAdmin as I said, but in the php page that received the POST and performed the insertion. The + is converted to <espaço> , to use the + character it is necessary to change it by %2B in the parameter to be passed.