ist wrote:
> Hi,
> I wish to create exactly the same SQL that backup module of PHPMyAdmin
> creates. I want to achieve it with ASP.NET, I have tried many times
> and get the nearest result with MyODBC driver. However, I am having
> problems with special characters (because the field contains encoded
> data), for example;
>
> -I have noticed that PHPMyAdmin creates SQL codes with \n characters,
> ASP.NET converts them to line breaks. I have corrected this by
> replacing \n's with \\n in ASP.NET
> -Similar situations occur in \ and ' characters, corrected them by
> replacing.
> -In PhpMyAdmin, there is a box character for an ASCII code, this
> occurs in ASP.NET as \b and so ASP.NET renders it as backspace.
>
> The third situation is weird, I haven't found how to handle it in a
> generic way. For example, I can manually replace \b's with box
> character, however this is only one situation and I may be missing
> many other special cases like this.
>
> So, the bottom line: How can I achieve exactly same SQL code with
> ASP.NET? Is there a special SQL Query for this (I am not talking about
> Backin-up to files), or if I have to do it manually, can I get a
> complete reference?
>
> Thanks...

don't understand your question complete but here's my two cents:
you can do is replace all of them "\b" to whatever you like before
running your query