Truncation error occured while converting data containing a single quote
-
I am trying to convert a column from nvarchar to varchar datatype using derived column.
Some of the records contain single quote (e.g. SQL's) When they are converted to varchar data type it is showing truncation error.
When I viewed error output from derived column, the single quote is replaced by a square like sign. Other characters are not changed.
The records which do not contain single quote are converted to varchar datatype successfully.
Did any one faced this problem? Any resolution?
-
which code page are you using for your conversion?
tom
Life: it twists and turns like a twisty turny thing
-
It is 1252
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply