Primal SQL query output UTF

Support for all customers who have purchased a PrimalSQL product license. This forum does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
edpatterson
Posts: 20
Joined: Wed Jan 06, 2010 11:52 pm

Primal SQL query output UTF

Post by edpatterson » Tue Mar 15, 2011 5:10 am

This might be a silly question but...Is there a way to get Primal SQL to save exported query results as ASCII instead of UTF-16?I am querying out of a MS SQL 2005 database and trying to use the resultant data in a VBScript file. I have to convert the data from UTF16 to ASCII before the windows script host and understand it.Scratching my head...Ed

User avatar
davidc
Posts: 5649
Joined: Thu Aug 18, 2011 4:56 am

Primal SQL query output UTF

Post by davidc » Fri Mar 18, 2011 7:24 am

Sorry for the late reply, I was away.
PrimalSQL doesn't offer the option to change the encoding, but it should retain the encoding of the file.

I believe you can use Notepad will allow you to change the encoding.

I will add this to the wish list.

David
David
SAPIEN Technologies, Inc.