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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics