If I want the results from a select statement written into a file i'll
use:

select * from employee
go
output to employee.csv format ASCII

but now I got the question to change the format into utf-8. how do I
do that ?

Or instead of usingthe format ascii I have to use UTF-8

You can use the ENCODING clause or set a temporary
option as in:


OUTPUT .... FROMAT ASCII ENCODING=UTF-8
or
SET TEMPORARY OPTION DEFAULT_ISQL_ENCODING = 'UTF-8'

[though there seems to be some confusion of whether or not that should be
'UTF8' without/with a hyphen]


"janis" <janimie (AT) gmail (DOT) com> wrote

> Or instead of usingthe format ascii I have to use UTF-8

Hi Nick, Thx for the quick response !!