Curious Question?
I have data in Excel having trademark signs like
PDP which i am loading in sql table and text file but when i load it to my sql table or text file the trademark shows as PDPSM.
The data type for that column in sql having this data is nvarchar.
I tried moving the data from excel with tradermak signs in their format using SSIS package but didnt work. It loads it as PDPSM.
My question is, if its showing the trademark symbols like PDPSM in sql table and text doc also, when i send text doc to the client and when they extract the data, will they see it as PDP or PDPSM? It should
be like PDP.
Thanks
September 22nd, 2011 12:07pm
Unfortunately, there is no straight forward method for this.
What you can do is to use the nchar or nvarchar data type and store the data in the form of HTML.
like : PDP <sup>SM</sup>
And decode it when reading back.
Hope this helpsSandeep Dasam
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
Free Windows Admin Tool Kit Click here and download it now
September 22nd, 2011 12:45pm
Thanks for your responce Sandeep.
i didnt understand "store the data in the form of HTML." do you mean when i load data in sql with datatype nvarchar it would be loaded in the form of text?
Also, Can you please elaborate where should i do that change PDP <sup>SM</sup> after loading data in sql?
September 22nd, 2011 12:56pm