如何在sql server中对guid进行base64编码

发布于 2025-01-03 15:49:01 字数 322 浏览 4 评论 0原文

如何在 sql server 2005 中使用 uniqueidentifier 数据类型重新创建以下 c# 代码。

string encoded = Convert.ToBase64String(guid.ToByteArray());

我尝试了在互联网上遇到的几个示例，例如 http://www.vbforums.com/showthread.php?t=554886 但它们都返回比.net 功能。

原文

How can I re-create the following c# code with a uniqueidentifier datatype in sql server 2005.

string encoded = Convert.ToBase64String(guid.ToByteArray());

I have tried several examples I came across on the internet such as http://www.vbforums.com/showthread.php?t=554886 but they all return strings much longer than the .net function.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

星軌x 2025-01-10 15:49:01

标识符，则链接中的示例有效

Guid guid = Guid.NewGuid();
string encoded = Convert.ToBase64String(guid.ToByteArray());
Console.WriteLine(guid);
Console.WriteLine(encoded);

唯一

32705fe3-cedd-4bfd-a881-9dd11e543f9e
419wMt3O/UuogZ3RHlQ/ng==

如果您传入And

declare @guid uniqueidentifier = '32705fe3-cedd-4bfd-a881-9dd11e543f9e'
select dbo.f_BinaryToBase64(@guid)

for 的

419wMt3O/UuogZ3RHlQ/ng==

The sample in your link works if you pass in a uniqueidentifier

Guid guid = Guid.NewGuid();
string encoded = Convert.ToBase64String(guid.ToByteArray());
Console.WriteLine(guid);
Console.WriteLine(encoded);

for

32705fe3-cedd-4bfd-a881-9dd11e543f9e
419wMt3O/UuogZ3RHlQ/ng==

And

declare @guid uniqueidentifier = '32705fe3-cedd-4bfd-a881-9dd11e543f9e'
select dbo.f_BinaryToBase64(@guid)

for

419wMt3O/UuogZ3RHlQ/ng==

回复收藏 0 原文

黎夕旧梦 2025-01-10 15:49:01

我的 guid 位于名为“guid”的 nvarchar(MAX) 列中，看起来像这样

 {4A449FE1-8989-4D69-935C-9E918244DEED}

采取几个步骤，即显示我的工作。我在表 guidreal、guidbinary、guidbase64 中添加了三列。我意识到这可以被压缩:-)。

update [Database].[dbo].[LotofRecords]
set guidreal =  Cast(Replace(Replace([guid],'{',''),'}','') AS UNIQUEIDENTIFIER)

update [Database].[dbo].[LotofRecords]
set guid_binary =  cast(guidreal as VARBINARY(MAX))

update [Database].[dbo].[LotofRecords]
set guidBase64 =   cast(N'' as XML).value(
              'xs:base64Binary(xs:hexBinary(sql:column("guid_binary")))'
              ,'nvarchar(25)'
              )

这让我

4Z9ESomJaU2TXJ6RgkTe7Q==

使用以下命令解码回 varbinary

select cast(N'' as XML).value(
              'xs:base64Binary(sql:column("guidbase64"))'
              ,'varbinary(max)'
              )
              ,guid_binary
from
 [Database].[dbo].[LotofRecords]

my guid's was in a nvarchar(MAX) column named 'guid' and looked like this

 {4A449FE1-8989-4D69-935C-9E918244DEED}

Taking a few steps i.e. showing my working. I added three columns to my table guidreal, guidbinary, guidbase64. I realise this can be compressed :-).

update [Database].[dbo].[LotofRecords]
set guidreal =  Cast(Replace(Replace([guid],'{',''),'}','') AS UNIQUEIDENTIFIER)

update [Database].[dbo].[LotofRecords]
set guid_binary =  cast(guidreal as VARBINARY(MAX))

update [Database].[dbo].[LotofRecords]
set guidBase64 =   cast(N'' as XML).value(
              'xs:base64Binary(xs:hexBinary(sql:column("guid_binary")))'
              ,'nvarchar(25)'
              )

which gave me

4Z9ESomJaU2TXJ6RgkTe7Q==

decode back to varbinary using

select cast(N'' as XML).value(
              'xs:base64Binary(sql:column("guidbase64"))'
              ,'varbinary(max)'
              )
              ,guid_binary
from
 [Database].[dbo].[LotofRecords]

回复收藏 0 原文