Hi.
I am using BCP utility to transfer data from SQL table to a delimited file.
Below is the example of the query used:
BCP "SELECT 1 as First,
quotename(COUNTRY,'""') as COUNTRY, STATUS, QUOTENAME('¸','""') as last FROM TableName " queryout "path of file" -T -S servername -d DBInstance -b 500 -c -C 65001 -t~
In the query the last character is ¸ - i mean QUOTENAME('¸','""')
But when the file is generated, the last character is coming as ?
what causes the character change while doing a BCP ?