Primal SQL query output UTF

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION 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.
This topic is 13 years and 1 week old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
edpatterson
Posts: 21
Last visit: Fri Jun 14, 2019 3:36 am

Primal SQL query output UTF

Post by edpatterson »

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: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Primal SQL query output UTF

Post by davidc »

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.
This topic is 13 years and 1 week old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.