Unicode export as SQL inserts - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Unicode export as SQL inserts

Print Thread

Unicode export as SQL inserts #28852 12/19/07 08:48 PM
Joined: Nov 2003 Posts: 35 F FrankMUC OP Member
OP FrankMUC Member F Joined: Nov 2003 Posts: 35	If I try to export a table which contains Unicode in NVARCHAR2 columns as SQL inserts (Tools->ExportTables->SQLInserts), PL/SQLDeveloper creates an ANSI Text file, which can not store Unicode data and the Unicode data is lost. Is there an option to configure PL/SQLDeveloper to create Unicode files instead which can store this data? Regards Frank

Re: Unicode export as SQL inserts #28853 12/19/07 10:55 PM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	Which PL/SQL Developer version are you using? Marco Kalter Allround Automations

Re: Unicode export as SQL inserts #28854 12/20/07 07:21 PM
Joined: Nov 2003 Posts: 35 F FrankMUC OP Member
OP FrankMUC Member F Joined: Nov 2003 Posts: 35	Version 7.1.4.1389 Regards Frank

Re: Unicode export as SQL inserts #28855 01/07/08 08:56 PM
Joined: Nov 2003 Posts: 35 F FrankMUC OP Member
OP FrankMUC Member F Joined: Nov 2003 Posts: 35	Hi, any news about this issue? Thanks Frank

Re: Unicode export as SQL inserts #28856 01/07/08 11:00 PM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	This seems like a bug. We'll fix it. Marco Kalter Allround Automations

Re: Unicode export as SQL inserts #28857 05/14/08 12:17 PM
Joined: Nov 2003 Posts: 35 F FrankMUC OP Member
OP FrankMUC Member F Joined: Nov 2003 Posts: 35	Hi, we still have this problem in 7.1.5.1396. Any chance to fix it with the next version? Thanks Frank

Re: Unicode export as SQL inserts #28858 05/14/08 02:40 PM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	It should be fixed in 8.0. Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.034s Queries: 13 (0.015s) Memory: 2.5208 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-18 06:43:25 UTC
Valid HTML 5 and Valid CSS