Re: question about postgresql dlr storage

2015-08-04 Thread spameden
2015-08-03 18:24 GMT+03:00 Alvaro Cornejo cornejo.alv...@gmail.com: Hi Marcin Seems you are getting the problem due to the ' on text Victoria's. Even though you are urlencoding it, it seems it is being taken as a field delimiter and not part of the text. I'm thinking on two options: -) Try

Re: question about postgresql dlr storage

2015-08-04 Thread Marcin Matyaszczyk
Hello The sms is submited like this:

Re: question about postgresql dlr storage

2015-08-04 Thread Jacek Raczkiewicz
I think in postgres you need to escape single quote by doubling it: Victoria's - Victoria''s 2015-08-04 9:08 GMT+02:00 spameden spame...@gmail.com: 2015-08-03 18:24 GMT+03:00 Alvaro Cornejo cornejo.alv...@gmail.com: Hi Marcin Seems you are getting the problem due to the ' on text

Re: question about postgresql dlr storage

2015-08-04 Thread Alexander Malysh
Hi, it should be converted to use prepared statements instead of plain sql string. Patches are welcome… Alex Am 04.08.2015 um 09:19 schrieb Marcin Matyaszczyk m.matyaszc...@ogicom.pl: Hello The sms is submited like this:

Re: question about postgresql dlr storage

2015-08-03 Thread Alvaro Cornejo
Hi Marcin Seems you are getting the problem due to the ' on text Victoria's. Even though you are urlencoding it, it seems it is being taken as a field delimiter and not part of the text. I'm thinking on two options: -) Try to escape it with \' or \\' -) You might want to replace any ' within