• rkjayaraj (6/21/2008)


    I have SQL Server database table with International characters. Is there any way I can bcp out the table into csv file in UTF-8 format?

    I have the same Problem, but my Destination is TXT.

    declare @pfad varchar(8000)

    set @pfad = 'bcp "select * from I_Kunden_EMail with (nolock)" queryout

    "\\Server\export\Emailadressen\email'+convert(varchar(10),getdate(),112)+'.txt" -T -t; -w '

    exec xp_cmdshell @pfad

    Which Parameters I need für UTF-8