开发者

Base64 in C# and PL/SQL?

In PL/SQL how can I convert a string (long HTML string with new line and tags, etc) to Base64 that is easy to decrypt in C#?

In C# there are:

Convert.ToBase64String()
Convert.ToBase64CharArray()
BitConverter.ToString()

which one is compatible with PL/SQL

utl_encode.bas开发者_C百科e64_encode();

?

I welcome any other suggestions :-)


You'll probably want to use this method:

Convert.ToBase64String()

It returns a Base64 encoded String based off an array of unsigned 8-bit integers (bytes).

As an alternate, you can use Convert.ToBase64CharArray(), but the output is a character array, which is a bit odd but may be useful in certain circumstances.

The method BitConverter.ToString() returns a String, but the bytes are represented in Hexadecimal, not Base64 encoded.


I done it :-)

PL/SQL

s1 varchar2(32767);
s2 varchar2(32767);

s2:= utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(s1)));
s2:= utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw(s1)));

are compatible with C#

public static string ToBase64(string str)
{
         return Convert.ToBase64String(Encoding.UTF8.GetBytes(str));
}

//++++++++++++++++++++++++++++++++++++++++++++++

public static string FromBase64(string str)
{
         return Encoding.UTF8.GetString(Convert.FromBase64String(str));
}

hope you find it useful :-)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜