What is the BCP command to get this trademark to export correctly. It shows up as T which is inncorrect:
CREATE TABLE myTestCharData (
Col1 smallint,
Col2 nvarchar(50),
Col3 nvarchar(50)
);
INSERT INTO myTestCharData(Col1,Col2,Col3)
VALUES(1,'DataField2','DataField3');
INSERT INTO myTestCharData(Col1,Col2,Col3)
VALUES(2,'DataField2','DataField™');
GO
SELECT Col1,Col2,Col3 FROM myTestCharData
master..xp_cmdshell 'bcp mii_data..myTestCharData out C:\text2.Dat -c -t, -T'