Toad World® Forums

TOAD 4.7 export encoding


#1

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

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

UNION

SELECT …

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:

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 earlier Toad versions.

This export is working well in Quest Central.

Any suggestion?

Message was edited by: rianas


#2

Message from: Helene

If you run the query without exporting the data does the result set display
correctly in Toad?


Historical Messages

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad?

__

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 earlier Toad versions.

This export is working well in Quest Central.

Any suggestion? Message was edited by: rianas
__



#3

If you run the query without exporting the data does the result set display correctly in Toad?


#4

Could you please send us the following information?

  1. A screen shot of the data grid showing the result of the query in Toad.
  2. Are you running Windows as US-English or Hungarian? Please include a screen shot of the Regional Setting for your Windows system.
  3. The DB parameters of the target database.

#5

[ Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= included below]

Message from: rianas

Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.


Historical Messages

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.
__

Author: Helene T. Rantz
Date: Wed Aug 18 08:25:52 PDT 2010
Could you please send us the following information?

  1. A screen shot of the data grid showing the result of the query in Toad.
  2. Are you running Windows as US-English or Hungarian? Please include a screen
    shot of the Regional Setting for your Windows system.
  3. The DB parameters of the target database.

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad?

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
Message from: Helene If you run the query without exporting the data does the
result set display correctly in Toad? _______________________________________
Historical Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __


__

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 earlier Toad versions.

This export is working well in Quest Central.

Any suggestion? Message was edited by: rianas
__


Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?=

3 of 3 Photo(s)

toad_grid_result.png

win7_regional_setting.png

DB_parameters.png


#6

Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.
toad_grid_result.png


#7

Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.


#8

Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.
DB_parameters.png


#9

Message from: Helene

Thank you for the information. We have reproduced the issue and are working on
it.


Historical Messages

Author: Helene T. Rantz
Date: Thu Aug 19 08:58:44 PDT 2010
Thank you for the information. We have reproduced the issue and are working on
it.

__

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.
__

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
[ Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= included below] Message
from: rianas Good questions. Yes, it display correctly in Toad. I am running
Windows as Hungarian. I hope to attached the requested screen shots.
_______________________________________ Historical Messages Author: Csécsi
Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes, it display
correctly in Toad. I am running Windows as Hungarian. I hope to attached the
requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18 08:25:52 PDT
2010 Could you please send us the following information? 1) A screen shot of the
data grid showing the result of the query in Toad. 2) Are you running Windows as
US-English or Hungarian? Please include a screen shot of the Regional Setting
for your Windows system. 4) The DB parameters of the target database. __ Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
exporting the data does the result set display correctly in Toad? __ Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message from: Helene If you
run the query without exporting the data does the result set display correctly
in Toad? _______________________________________ Historical Messages Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
exporting the data does the result set display correctly in Toad? __ 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 earlier Toad
versions. This export is working well in Quest Central. Any suggestion? Message
was edited by: rianas __ _______________________________________ __ 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 earlier Toad
versions. This export is working well in Quest Central. Any suggestion? Message
was edited by: rianas __ _______________________________________ Attachment(s)
from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
win7_regional_setting.png DB_parameters.png
__

Author: Helene T. Rantz
Date: Wed Aug 18 08:25:52 PDT 2010
Could you please send us the following information?

  1. A screen shot of the data grid showing the result of the query in Toad.
  2. Are you running Windows as US-English or Hungarian? Please include a screen
    shot of the Regional Setting for your Windows system.
  3. The DB parameters of the target database.

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad?

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
Message from: Helene If you run the query without exporting the data does the
result set display correctly in Toad? _______________________________________
Historical Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __


__

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 earlier Toad versions.

This export is working well in Quest Central.

Any suggestion? Message was edited by: rianas
__



#10

Thank you for the information. We have reproduced the issue and are working on it.


#11

Message from: Helene

If you could please try a test for us.

  1. From the ‘Toad for DB2’ DB2 command window issue the following
    commands.

db2set DB2CODEPAGE=1208

db2 terminate

  1. Close and reopen Toad for DB2.

  2. Retry the export and let us know what the result is.


Historical Messages

Author: Helene T. Rantz
Date: Thu Aug 19 14:25:51 PDT 2010

If you could please try a test for us.

  1. From the ‘Toad for DB2’ DB2 command window issue the following
    commands.

db2set DB2CODEPAGE=1208

db2 terminate

  1. Close and reopen Toad for DB2.

  2. Retry the export and let us know what the result is.

__

Author: Helene T. Rantz
Date: Thu Aug 19 08:58:44 PDT 2010
Thank you for the information. We have reproduced the issue and are working on
it.

__

Author: Helene T. Rantz
Date: Thu Aug 19 08:58:44 PDT 2010
Message from: Helene Thank you for the information. We have reproduced the issue
and are working on it. _______________________________________ Historical
Messages Author: Helene T. Rantz Date: Thu Aug 19 08:58:44 PDT 2010 Thank you
for the information. We have reproduced the issue and are working on it. __
Author: Csécsi Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes,
it display correctly in Toad. I am running Windows as Hungarian. I hope to
attached the requested screen shots. __ Author: Csécsi Adrián Date: Wed Aug 18
13:50:53 PDT 2010 [ Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?=
included below] Message from: rianas Good questions. Yes, it display correctly
in Toad. I am running Windows as Hungarian. I hope to attached the requested
screen shots. _______________________________________ Historical Messages
Author: Csécsi Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes,
it display correctly in Toad. I am running Windows as Hungarian. I hope to
attached the requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18
08:25:52 PDT 2010 Could you please send us the following information? 1) A
screen shot of the data grid showing the result of the query in Toad. 2) Are you
running Windows as US-English or Hungarian? Please include a screen shot of the
Regional Setting for your Windows system. 4) The DB parameters of the target
database. __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you
run the query without exporting the data does the result set display correctly
in Toad? __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message
from: Helene If you run the query without exporting the data does the result set
display correctly in Toad? _______________________________________ Historical
Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run
the query without exporting the data does the result set display correctly in
Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __
_______________________________________ __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __
_______________________________________ Attachment(s) from
=?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
win7_regional_setting.png DB_parameters.png __ Author: Helene T. Rantz Date: Wed
Aug 18 08:25:52 PDT 2010 Could you please send us the following information? 1)
A screen shot of the data grid showing the result of the query in Toad. 2) Are
you running Windows as US-English or Hungarian? Please include a screen shot of
the Regional Setting for your Windows system. 4) The DB parameters of the target
database. __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you
run the query without exporting the data does the result set display correctly
in Toad? __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message
from: Helene If you run the query without exporting the data does the result set
display correctly in Toad? _______________________________________ Historical
Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run
the query without exporting the data does the result set display correctly in
Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __
_______________________________________ __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __


__

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.
__

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
[ Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= included below] Message
from: rianas Good questions. Yes, it display correctly in Toad. I am running
Windows as Hungarian. I hope to attached the requested screen shots.
_______________________________________ Historical Messages Author: Csécsi
Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes, it display
correctly in Toad. I am running Windows as Hungarian. I hope to attached the
requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18 08:25:52 PDT
2010 Could you please send us the following information? 1) A screen shot of the
data grid showing the result of the query in Toad. 2) Are you running Windows as
US-English or Hungarian? Please include a screen shot of the Regional Setting
for your Windows system. 4) The DB parameters of the target database. __ Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
exporting the data does the result set display correctly in Toad? __ Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message from: Helene If you
run the query without exporting the data does the result set display correctly
in Toad? _______________________________________ Historical Messages Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
exporting the data does the result set display correctly in Toad? __ 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 earlier Toad
versions. This export is working well in Quest Central. Any suggestion? Message
was edited by: rianas __ _______________________________________ __ 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 earlier Toad
versions. This export is working well in Quest Central. Any suggestion? Message
was edited by: rianas __ _______________________________________ Attachment(s)
from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
win7_regional_setting.png DB_parameters.png
__

Author: Helene T. Rantz
Date: Wed Aug 18 08:25:52 PDT 2010
Could you please send us the following information?

  1. A screen shot of the data grid showing the result of the query in Toad.
  2. Are you running Windows as US-English or Hungarian? Please include a screen
    shot of the Regional Setting for your Windows system.
  3. The DB parameters of the target database.

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad?

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
Message from: Helene If you run the query without exporting the data does the
result set display correctly in Toad? _______________________________________
Historical Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __


__

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 earlier Toad versions.

This export is working well in Quest Central.

Any suggestion? Message was edited by: rianas
__



#12

If you could please try a test for us.

  1. From the ‘Toad for DB2’ DB2 command window issue the following commands.

db2set DB2CODEPAGE=1208

db2 terminate

  1. Close and reopen Toad for DB2.

  2. Retry the export and let us know what the result is


#13

Message from: rianas

I used ‘Tools\DB2 Command Window…’ window first, but I realized that I
have to quit from the db2 promt to run the script.
Retrying the export the result is still correct in the Toad window, but in the
exported file both header and data display as ANSI text, but in UTF-8 like this:

Azonosçtó szám;SzemÈly nevek
1 ;Gipsz Jakab
2 ;Nagy GÈza
3 ;Minta Mihály
4 ;Kovács Ágnes
5 ;├¾r├Âm ├¾d├Ân


Historical Messages

Author: Csécsi Adrián
Date: Mon Aug 23 04:53:47 PDT 2010
I used ‘Tools\DB2 Command Window…’ window first, but I realized that I
have to quit from the db2 promt to run the script.
Retrying the export the result is still correct in the Toad window, but in the
exported file both header and data display as ANSI text, but in UTF-8 like this:

Azonosçtó szám;SzemÈly nevek
1 ;Gipsz Jakab
2 ;Nagy GÈza
3 ;Minta Mihály
4 ;Kovács Ágnes
5 ;├¾r├Âm ├¾d├Ân

__

Author: Helene T. Rantz
Date: Thu Aug 19 14:25:51 PDT 2010

If you could please try a test for us.

  1. From the ‘Toad for DB2’ DB2 command window issue the following
    commands.

db2set DB2CODEPAGE=1208

db2 terminate

  1. Close and reopen Toad for DB2.

  2. Retry the export and let us know what the result is
    __

Author: Helene T. Rantz
Date: Thu Aug 19 14:25:51 PDT 2010
Message from: Helene If you could please try a test for us. 1) From the
‘Toad for DB2’ DB2 command window issue the following commands. db2set
DB2CODEPAGE=1208 db2 terminate 2) Close and reopen Toad for DB2. 3) Retry the
export and let us know what the result is.
_______________________________________ Historical Messages Author: Helene T.
Rantz Date: Thu Aug 19 14:25:51 PDT 2010 If you could please try a test for us.

  1. From the ‘Toad for DB2’ DB2 command window issue the following
    commands. db2set DB2CODEPAGE=1208 db2 terminate 2) Close and reopen Toad for
    DB2. 3) Retry the export and let us know what the result is. __ Author: Helene
    T. Rantz Date: Thu Aug 19 08:58:44 PDT 2010 Thank you for the information. We
    have reproduced the issue and are working on it. __ Author: Helene T. Rantz
    Date: Thu Aug 19 08:58:44 PDT 2010 Message from: Helene Thank you for the
    information. We have reproduced the issue and are working on it.
    _______________________________________ Historical Messages Author: Helene T.
    Rantz Date: Thu Aug 19 08:58:44 PDT 2010 Thank you for the information. We have
    reproduced the issue and are working on it. __ Author: Csécsi Adrián Date: Wed
    Aug 18 13:50:53 PDT 2010 Good questions. Yes, it display correctly in Toad. I am
    running Windows as Hungarian. I hope to attached the requested screen shots. __
    Author: Csécsi Adrián Date: Wed Aug 18 13:50:53 PDT 2010 [ Attachment(s) from
    =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= included below] Message from: rianas Good
    questions. Yes, it display correctly in Toad. I am running Windows as Hungarian.
    I hope to attached the requested screen shots.
    _______________________________________ Historical Messages Author: Csécsi
    Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes, it display
    correctly in Toad. I am running Windows as Hungarian. I hope to attached the
    requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18 08:25:52 PDT
    2010 Could you please send us the following information? 1) A screen shot of the
    data grid showing the result of the query in Toad. 2) Are you running Windows as
    US-English or Hungarian? Please include a screen shot of the Regional Setting
    for your Windows system. 4) The DB parameters of the target database. __ Author:
    Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
    exporting the data does the result set display correctly in Toad? __ Author:
    Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message from: Helene If you
    run the query without exporting the data does the result set display correctly
    in Toad? _______________________________________ Historical Messages Author:
    Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
    exporting the data does the result set display correctly in Toad? __ 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 earlier Toad
    versions. This export is working well in Quest Central. Any suggestion? Message
    was edited by: rianas __ _______________________________________ __ 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 earlier Toad
    versions. This export is working well in Quest Central. Any suggestion? Message
    was edited by: rianas __ _______________________________________ Attachment(s)
    from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
    win7_regional_setting.png DB_parameters.png __ Author: Helene T. Rantz Date: Wed
    Aug 18 08:25:52 PDT 2010 Could you please send us the following information? 1)
    A screen shot of the data grid showing the result of the query in Toad. 2) Are
    you running Windows as US-English or Hungarian? Please include a screen shot of
    the Regional Setting for your Windows system. 4) The DB parameters of the target
    database. __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you
    run the query without exporting the data does the result set display correctly
    in Toad? __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message
    from: Helene If you run the query without exporting the data does the result set
    display correctly in Toad? _______________________________________ Historical
    Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run
    the query without exporting the data does the result set display correctly in
    Toad? __ 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 earlier Toad versions. This export is working well in Quest
    Central. Any suggestion? Message was edited by: rianas __
    _______________________________________ __ 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 earlier Toad versions. This export is working well in Quest
    Central. Any suggestion? Message was edited by: rianas __
    _______________________________________ __ Author: Csécsi Adrián Date: Wed Aug
    18 13:50:53 PDT 2010 Good questions. Yes, it display correctly in Toad. I am
    running Windows as Hungarian. I hope to attached the requested screen shots. __
    Author: Csécsi Adrián Date: Wed Aug 18 13:50:53 PDT 2010 [ Attachment(s) from
    =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= included below] Message from: rianas Good
    questions. Yes, it display correctly in Toad. I am running Windows as Hungarian.
    I hope to attached the requested screen shots.
    _______________________________________ Historical Messages Author: Csécsi
    Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes, it display
    correctly in Toad. I am running Windows as Hungarian. I hope to attached the
    requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18 08:25:52 PDT
    2010 Could you please send us the following information? 1) A screen shot of the
    data grid showing the result of the query in Toad. 2) Are you running Windows as
    US-English or Hungarian? Please include a screen shot of the Regional Setting
    for your Windows system. 4) The DB parameters of the target database. __ Author:
    Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
    exporting the data does the result set display correctly in Toad? __ Author:
    Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message from: Helene If you
    run the query without exporting the data does the result set display correctly
    in Toad? _______________________________________ Historical Messages Author:
    Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
    exporting the data does the result set display correctly in Toad? __ 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 earlier Toad
    versions. This export is working well in Quest Central. Any suggestion? Message
    was edited by: rianas __ _______________________________________ __ 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 earlier Toad
    versions. This export is working well in Quest Central. Any suggestion? Message
    was edited by: rianas __ _______________________________________ Attachment(s)
    from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
    win7_regional_setting.png DB_parameters.png __ Author: Helene T. Rantz Date: Wed
    Aug 18 08:25:52 PDT 2010 Could you please send us the following information? 1)
    A screen shot of the data grid showing the result of the query in Toad. 2) Are
    you running Windows as US-English or Hungarian? Please include a screen shot of
    the Regional Setting for your Windows system. 4) The DB parameters of the target
    database. __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you
    run the query without exporting the data does the result set display correctly
    in Toad? __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message
    from: Helene If you run the query without exporting the data does the result set
    display correctly in Toad? _______________________________________ Historical
    Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run
    the query without exporting the data does the result set display correctly in
    Toad? __ 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 earlier Toad versions. This export is working well in Quest
    Central. Any suggestion? Message was edited by: rianas __
    _______________________________________ __ 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 earlier Toad versions. This export is working well in Quest
    Central. Any suggestion? Message was edited by: rianas __

__

Author: Helene T. Rantz
Date: Thu Aug 19 08:58:44 PDT 2010
Thank you for the information. We have reproduced the issue and are working on
it.

__

Author: Helene T. Rantz
Date: Thu Aug 19 08:58:44 PDT 2010
Message from: Helene Thank you for the information. We have reproduced the issue
and are working on it. _______________________________________ Historical
Messages Author: Helene T. Rantz Date: Thu Aug 19 08:58:44 PDT 2010 Thank you
for the information. We have reproduced the issue and are working on it. __
Author: Csécsi Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes,
it display correctly in Toad. I am running Windows as Hungarian. I hope to
attached the requested screen shots. __ Author: Csécsi Adrián Date: Wed Aug 18
13:50:53 PDT 2010 [ Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?=
included below] Message from: rianas Good questions. Yes, it display correctly
in Toad. I am running Windows as Hungarian. I hope to attached the requested
screen shots. _______________________________________ Historical Messages
Author: Csécsi Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes,
it display correctly in Toad. I am running Windows as Hungarian. I hope to
attached the requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18
08:25:52 PDT 2010 Could you please send us the following information? 1) A
screen shot of the data grid showing the result of the query in Toad. 2) Are you
running Windows as US-English or Hungarian? Please include a screen shot of the
Regional Setting for your Windows system. 4) The DB parameters of the target
database. __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you
run the query without exporting the data does the result set display correctly
in Toad? __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message
from: Helene If you run the query without exporting the data does the result set
display correctly in Toad? _______________________________________ Historical
Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run
the query without exporting the data does the result set display correctly in
Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __
_______________________________________ __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __
_______________________________________ Attachment(s) from
=?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
win7_regional_setting.png DB_parameters.png __ Author: Helene T. Rantz Date: Wed
Aug 18 08:25:52 PDT 2010 Could you please send us the following information? 1)
A screen shot of the data grid showing the result of the query in Toad. 2) Are
you running Windows as US-English or Hungarian? Please include a screen shot of
the Regional Setting for your Windows system. 4) The DB parameters of the target
database. __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you
run the query without exporting the data does the result set display correctly
in Toad? __ Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message
from: Helene If you run the query without exporting the data does the result set
display correctly in Toad? _______________________________________ Historical
Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run
the query without exporting the data does the result set display correctly in
Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __
_______________________________________ __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __


__

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
Good questions.
Yes, it display correctly in Toad.
I am running Windows as Hungarian.
I hope to attached the requested screen shots.
__

Author: Csécsi Adrián
Date: Wed Aug 18 13:50:53 PDT 2010
[ Attachment(s) from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= included below] Message
from: rianas Good questions. Yes, it display correctly in Toad. I am running
Windows as Hungarian. I hope to attached the requested screen shots.
_______________________________________ Historical Messages Author: Csécsi
Adrián Date: Wed Aug 18 13:50:53 PDT 2010 Good questions. Yes, it display
correctly in Toad. I am running Windows as Hungarian. I hope to attached the
requested screen shots. __ Author: Helene T. Rantz Date: Wed Aug 18 08:25:52 PDT
2010 Could you please send us the following information? 1) A screen shot of the
data grid showing the result of the query in Toad. 2) Are you running Windows as
US-English or Hungarian? Please include a screen shot of the Regional Setting
for your Windows system. 4) The DB parameters of the target database. __ Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
exporting the data does the result set display correctly in Toad? __ Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 Message from: Helene If you
run the query without exporting the data does the result set display correctly
in Toad? _______________________________________ Historical Messages Author:
Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010 If you run the query without
exporting the data does the result set display correctly in Toad? __ 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 earlier Toad
versions. This export is working well in Quest Central. Any suggestion? Message
was edited by: rianas __ _______________________________________ __ 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 earlier Toad
versions. This export is working well in Quest Central. Any suggestion? Message
was edited by: rianas __ _______________________________________ Attachment(s)
from =?ISO-8859-1?Q?Cs=E9csi_Adri=E1n?= 3 of 3 Photo(s) toad_grid_result.png
win7_regional_setting.png DB_parameters.png
__

Author: Helene T. Rantz
Date: Wed Aug 18 08:25:52 PDT 2010
Could you please send us the following information?

  1. A screen shot of the data grid showing the result of the query in Toad.
  2. Are you running Windows as US-English or Hungarian? Please include a screen
    shot of the Regional Setting for your Windows system.
  3. The DB parameters of the target database.

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad?

__

Author: Helene T. Rantz
Date: Wed Aug 18 07:43:08 PDT 2010
Message from: Helene If you run the query without exporting the data does the
result set display correctly in Toad? _______________________________________
Historical Messages Author: Helene T. Rantz Date: Wed Aug 18 07:43:08 PDT 2010
If you run the query without exporting the data does the result set display
correctly in Toad? __ 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 earlier Toad versions. This export is working well in Quest
Central. Any suggestion? Message was edited by: rianas __


__

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 earlier Toad versions.

This export is working well in Quest Central.

Any suggestion? Message was edited by: rianas
__



#14

I used ‘Tools\DB2 Command Window…’ window first, but I realized that I have to quit from the db2 promt to run the script.
Retrying the export the result is still correct in the Toad window, but in the exported file both header and data display as ANSI text, but in UTF-8 like this:

Azonosçtó szám;SzemÈly nevek
1 ;Gipsz Jakab
2 ;Nagy GÈza
3 ;Minta Mihály
4 ;Kovács Ágnes
5 ;├¾r├Âm ├¾d├Ân