SQL Script Builder News Feed
Advanced search  

 

Oracle datatypes

General tips on using SQL Script Builder

Oracle datatypes

Postby Chris Metcalfe » Wed Jan 07, 2009 13:48

I am trying to use your product (v2.1.0.22) to move an old database accessible via ODBC to an Oracle 10G database for archive puposes. I can generate scripts for just the table structure and or the data without any particualr problem expect for the fact that the character fields in the resulting table structure are being defined are nvarchar2 format rather than the varchar2 format I would prefer. I could do a global replace but I would be happier if the scripts were generated in this form in the first place. Is there any way to change the default varchar2 data type please ?

Thanks

Chris
Chris Metcalfe
 
Posts: 1
Joined: Wed Jan 07, 2009 13:48

Re: Oracle datatypes

Postby admin » Fri Jan 09, 2009 12:23

No, there's no way of changing that.
User avatar
admin
Site Admin
 
Posts: 60
Joined: Sat Jan 08, 2005 08:09


Return to Application Usage

Who is online

Users browsing this forum: No registered users and 0 guests

cron