RE: [sqr-users] plain text into base-64 encoded Unicode text

[<Ravishankar.B@cognizant.com>]

Hi Arun:
 
I don't think you can encode data using any SQR function. But, Oracle has some 
packages for encoding data.
 
Try your luck in this link: 
http://blogs.ittoolbox.com/oracle/guide/archives/binary-xml-compressing-encrypting-and-encoding-data-in-oracle-6688
 
 
 
Sincerely,
 
Ravi
920-924-5912(W)

________________________________

From: sqr-users-bounces+ravishankar.b=cognizant.com@sqrug.org on behalf of Arun 
Kumar
Sent: Fri 7/13/2007 8:29 PM
To: This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.
Subject: [sqr-users] plain text into base-64 encoded Unicode text



Hi all,

I need to send a text for resetting the password to another utility in a 
Unicode format and base-64 encoded.

There are several utility on web that can convert a string in this format.

Here is how one such utility works..

Q:\download>stringconverter \"stringtochange\" /encode /unicode
IgBzAHQAcgBpAG4AZwB0AG8AYwBoAGEAbgBnAGUAIgA=

the unicoded and encoded value for the string "stringtochange" = 
'IgBzAHQAcgBpAG4AZwB0AG8AYwBoAGEAbgBnAGUAIgA='

But I need to do it within the sqr either using SQR funtions or ORACLE function 
availalable.

Can this be done?

any help or direction would be nice...


Arun Kumar




      
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows. 
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545433

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users