Re: Escaping escaped chars

One of the guys over on the php-db list told me that to store the binary string correctly in postrgresql, that I would have to double quote whats already there. So in essence, by the time it hits the database, it has to be -> \\\0PZ\\\0<Îê˜Úµ Any suggestions to modify the string like this... Maybe I should be looking into one of the preg functions.... Thank You. Michael Sweeney wrote:

Just escape the \ with a single escape character. eg. your string '\0PZ\0<Îê˜Úµ' would end up as '\\0PZ\\0<Îê˜Úµ' - each \ simply escapes the backslash following it. If you add two backslashes, you end up with one too many which is what the error is referring to. ..micahel.. On Thu, 2002-06-20 at 10:59, Gerard Samuel wrote:

Im trying to move some binary strings from mysql to postgresql, and the binary strings has escape chars '\' in them. I was told to double escape them like so -> '\\\' Here is what Im trying -> $data = '\0PZ\0<Îê˜Úµ'; // This is a representation from an mysql dump $data2 = str_replace('/\', '/\/\/\', $data); Im getting -> Unexpected character in input: '\' (ASCII=92) state=1 I guess my str_replace() isn't correct. Am I going about the right way to double escape them. Thanks.

-- Gerard Samuel http://www.trini0.org:81/ http://dev.trini0.org:81/