using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Text;
public partial class UserDefinedFunctions
{
/// <summary>
/// 20290 IBM290 IBM EBCDIC (日本語カタカナ)
/// </summary>
/// <param name="target">文字列</param>
/// <param name="length">文字数</param>
/// <returns>byte[]</returns>
[Microsoft.SqlServer.Server.SqlFunction]
public static byte[] EBCDIC(string target, int length)
{
string wTarget = target.PadRight(length, ' ');
Encoding encoding = Encoding.GetEncoding(20290);
byte[] bytes = encoding.GetBytes(wTarget);
return bytes;
}
};