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 = '\0PZ\0Îê˜Úµ'; // This is a representation from an mysql dump
$data2 = str_replace('/\',
Just escape the \ with a single escape character. eg. your string
'\0PZ\0Îê˜Úµ' would end up as '\\0PZ\\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,
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 -
\\\0PZ\\\0Îê˜Úµ
Any suggestions to modify the string like this...
3 matches
Mail list logo