I am using Toad 10.1 to extract data from a database in order to use it with another application. This application needs the data files to be in unicode text file format or else the text fields will not come in properly. I can export delimited text files as ANSI or UTF-8 but not unicode and was hoping that there was a solution to this that someone knows about.
If the dataset is small enough I can always open it in notepad and save it as unicode but now I have some files that are too large to be opened in notepad. If I could just extract them as unicode in the first place it would prevent this issue altogether. Is there a way to do that?
I don’t have Toad 10.1 installed anywhere, but in 10.5 and newer there is a dropdown for “Encoding” right on the ‘export data’ dialog in Toad. If you don’t
see that, then an upgrade will get you this feature.
I am using Toad 10.1 to extract data from a database in order to use it with another application. This application needs the data files to be in unicode text file format or else the text fields
will not come in properly. I can export delimited text files as ANSI or UTF-8 but not unicode and was hoping that there was a solution to this that someone knows about.
If the dataset is small enough I can always open it in notepad and save it as unicode but now I have some files that are too large to be opened in notepad. If I could just extract them as unicode
in the first place it would prevent this issue altogether. Is there a way to do that?