When generating insert statements for a table that contains ntext datatype with RTF value, Toad adds extra slashes to the data.
Example:
1. In Database Browser | Tables tab | Right click on a table that contains ntext datatype with RTF value | export | generate insert statements
Attached is a backup file which contains this table and data. When exporting it to a text file it works fine, but not as
The data stored in the database is:
{\f0\fswiss\fcharset0\fprq2 Arial;}
{\f1\froman\fcharset0\fprq2 Times New Roman;}
{\f2\froman\fcharset2\fprq2 Symbol;}}
{\colortbl;\red0\green0\blue0;\red255\green255\blue255;\red0\green0\blue255;}
{\stylesheet{\s0\itap0\f1\fs20 Normal;}{\*\cs10\additive Default Paragraph Font;}{\s16\itap0\f0\fs24 [Normal];}}
{\*\generator TX_RTF32 12.0.500.502;}
\deftab1134\paperw9072\paperh25920\margl0\margt0\margr0\margb0\notabind\pard\itap0\tx720\plain\f0\fs18\cf3\up4 Standard: Writing Processes\par\pard\s16\itap0 Benchmark: (D) Edit to improve sentence fluency, grammar and usage. \plain\f0\fs18\b\cf3\up4 __________________________________________________________________________________________\par\plain\f0\fs18\b Read the draft paragraph and answer question 5.\par\plain\f0\fs18\up3\par{\field{\*\fldinst INCLUDEPICTURE "Images/16aaa7ac-fa35-4b73-882d-e76d57a914f0.wmf" \\d}{\fldrslt {}}}\par\par In the context of the paragraph, which is the correct way to revise and/or edit sentence 3? }
The exported data shows
{\\f0\\fswiss\\fcharset0\\fprq2 Arial;}
{\\f1\\froman\\fcharset0\\fprq2 Times New Roman;}
{\\f2\\froman\\fcharset2\\fprq2 Symbol;}}
{\\colortbl;\\red0\\green0\\blue0;\\red255\\green255\\blue255;\\red0\\green0\\blue255;}
{\\stylesheet{\\s0\\itap0\\f1\\fs20 Normal;}{\\*\\cs10\\additive Default Paragraph Font;}{\\s16\\itap0\\f0\\fs24 [Normal];}}
{\\*\\generator TX_RTF32 12.0.500.502;}
\\deftab1134\
WORKAROUND:
None
STATUS:
Issue fixed in version 3.1.
The latest version of Toad for SQL Server can be downloaded at the Support Portal.
Click here.
