Toad World® Forums

TOAD 4.7 export encoding


#1

Message from: rianas

Hi!

I haven’t been abled to solve this problem for a week.

I would like to export a query to a csv file with hungarian header like this:

EXPORT TO ‘export_file.csv’ OF DEL modified by coldel ; nochardel

VALUES ( ‘Azonosító szám’ , ‘Személy nevek’ ) ;

UNION

SELECT …

but opening the csv file I get wrong character encoding in unicode:
AzonosÃtó szám Személy nevek

On the another hand the SELECT part is right.
A tried to set the export codepage by ‘codepage=1250’, and set the
editor Charachter Encoding to ‘közép-európai (Windows)’, and set
Options\Editor\General\File encoding type to the same ‘közép-európai
(Windows)’ but the results are the same.

I am useing Toad 7.4.0.506 Beta but I tried lots of later Toad versions.

This export is working well in Quest Central.

Any suggestion?


Historical Messages

Author: Csécsi Adrián
Date: Wed Aug 18 03:55:00 PDT 2010
Hi!

I haven’t been abled to solve this problem for a week.

I would like to export a query to a csv file with hungarian header like this:

EXPORT TO ‘export_file.csv’ OF DEL modified by coldel ; nochardel

VALUES ( ‘Azonosító szám’ , ‘Személy nevek’ ) ;

UNION

SELECT …

but opening the csv file I get wrong character encoding in unicode:
AzonosÃtó szám Személy nevek

On the another hand the SELECT part is right.
A tried to set the export codepage by ‘codepage=1250’, and set the
editor Charachter Encoding to ‘közép-európai (Windows)’, and set
Options\Editor\General\File encoding type to the same ‘közép-európai
(Windows)’ but the results are the same.

I am useing Toad 7.4.0.506 Beta but I tried lots of later Toad versions.

This export is working well in Quest Central.

Any suggestion?
__