Hi,

I cannot use the ENCODING parameter, it gives a syntax error (syntaxc error
near encoding).
UNLOAD TABLE mytable TO 'mytable_data_in_utf8.dat' ENCODING 'UTF-8';

Tried this using version 9 and 10 .
Without this parameter all is working well.

A customer needs csv-files utf8 encoded, the DN is set to 1252LATIN1.
I created a stored procedure filling temp tables and i unload this using
execute immediate.
However the ENCODING part is not working..

Regards,

Marc

ENCODING was added with V10 so you will get "syntax error" in V9.

I just tried it with V10 and it worked OK, so you should contact
technical support for further assistance.

Breck


SQL Anywhere Personal Server Version 10.0.1.3415

create table mytable ( pkey integer );
insert mytable values ( 1 );
commit;
UNLOAD TABLE mytable TO 'mytable_data_in_utf8.dat' ENCODING 'UTF-8';

Execution time: 0.203 seconds
Execution time: 0.047 seconds
Execution time: 0.14 seconds
Execution time: 0.032 seconds


On 3 Aug 2009 01:46:44 -0700, "Marc van Roosmalen"
<mvanroosmalen (AT) inforit (DOT) nl> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Thanks for your reply.
You are right (of course), i'm using isql on a 9 database.

Is there a workaround in 9, e.g. declare the temp table as utf8??

Regards,

Marc




"Breck Carter [TeamSybase]" <NOSPAM__breck.carter (AT) gmail (DOT) com> wrote in
message news:0tkd75tmvecn95nl21dfkhv70mcgl23krq (AT) 4ax (DOT) com...

I don't know... you should post this question as a new topic (not a
reply to this topic) so more people will read it.

Breck

On 5 Aug 2009 06:12:09 -0700, "Marc van Roosmalen"
<mvanroosmalen (AT) inforit (DOT) nl> wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com