blocks|key|2663832|text|如果您查看所涉及的十六进制数字的值(成对)，您可以看到最后7个字节在这两种情况下都是相同的，但是前9个是稍微切换的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2663833|从您的示例来看，但是将.NET中的每一对重写为00、11、22等，并切换Oracle的相关字节，我们得到：|2663834|2663835|.NET：|unordered-list-item|2663836|2663837|00112233445566778899AABBCCDDEEFF|2663838|Oracle：|2663839|2663840|33221100554477668899AABBCCFFEEFF|2663841|因此，编写代码来转换相关字节应该相当容易。(事实上，我很确定我在以前的工作中写了一些代码来完成这个任务。)|2663842|要切换字节，只需调用Guid.ToByteArray()和new+Guid(byte[])以返回Guid。|offset|length|style|CODE|2663843|编辑:正如发生的那样，上面的切换正是Guid构造函数在传递字节数组时所做的工作：|2663844|using+System;
using+System.Linq;

class+Test
{
++++static+void+Main()
++++{
++++++++byte[]+bytes+=+Enumerable.Range(0,+16)
+++++++++++++++++++++++++++++++++.Select(x+=>+x+*+16+%2B+x)
+++++++++++++++++++++++++++++++++.Select(x+=>+(byte)+x)
+++++++++++++++++++++++++++++++++.ToArray();

++++++++Console.WriteLine(BitConverter.ToString(bytes).Replace("-",+""));
++++++++Console.WriteLine(new+Guid(bytes).ToString().Replace("-",+""));
++++}
}|code-block|syntax|javascript|2663845|指纹：|2663846|00112233445566778899AABBCCDDEEFF
33221100554477668899aabbccddeeff|2663847|这可能会大大简化转换操作.你是如何从一开始就得到这些值的？这仅仅是“它们在Oracle中的显示方式”吗？|2663848|编辑:好的，这里有几个转换函数--如果你把数据作为文本，它们会以每一种方式转换.|2663849|using+System;
using+System.Linq;

class+Test
{
++++static+void+Main()
++++{
++++++++string+oracle+=+"329DD817216CD6429B989F5201288DBF";
++++++++string+dotNet+=+"17D89D326C2142D69B989F5201288DBF";

++++++++Console.WriteLine(oracle+==+DotNetToOracle(dotNet));
++++++++Console.WriteLine(dotNet+==+OracleToDotNet(oracle));
++++}

++++static+string+OracleToDotNet(string+text)
++++{
++++++++byte[]+bytes+=+ParseHex(text);
++++++++Guid+guid+=+new+Guid(bytes);
++++++++return+guid.ToString("N").ToUpperInvariant();
++++}

++++static+string+DotNetToOracle(string+text)
++++{
++++++++Guid+guid+=+new+Guid(text);
++++++++return+BitConverter.ToString(guid.ToByteArray()).Replace("-",+"");
++++}

++++static+byte[]+ParseHex(string+text)
++++{
++++++++//+Not+the+most+efficient+code+in+the+world,+but
++++++++//+it+works...
++++++++byte[]+ret+=+new+byte[text.Length+/+2];
++++++++for+(int+i+=+0;+i+<+ret.Length;+i%2B%2B)
++++++++{
++++++++++++ret[i]+=+Convert.ToByte(text.Substring(i+*+2,+2),+16);
++++++++}
++++++++return+ret;
++++}

}|2663850|entityMap^0|0|0|0|0|0|0|0|0|0|0|A|I|T|G|1C|4|0|I|4|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|1J|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1L|8|@]|9|@]|A|$]]|$1|K|3|L|5|G|7|1M|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1O|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1P|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1Q|8|@$T|1R|U|1S|V|W]|$T|1T|U|1U|V|W]|$T|1V|U|1W|V|W]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1X|8|@$T|1Y|U|1Z|V|W]]|9|@]|A|$]]|$1|Z|3|10|5|11|7|20|8|@]|9|@]|A|$12|13]]|$1|14|3|15|5|6|7|21|8|@]|9|@]|A|$]]|$1|16|3|17|5|11|7|22|8|@]|9|@]|A|$12|13]]|$1|18|3|19|5|6|7|23|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|24|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|11|7|25|8|@]|9|@]|A|$12|13]]|$1|1E|3|-4|5|6|7|26|8|@]|9|@]|A|$]]]|1F|$]]

If you look at the values involved (in pairs) of hex digits you can see that the last 7 bytes are the same in both cases, but the first 9 are switched around a bit.

Going from your example, but rewriting each pair in the .NET as 00, 11, 22 etc and switching the relevant byte of Oracle as well we get:

<ul>
<li>.NET: 

<pre><code>00112233445566778899AABBCCDDEEFF
</code></pre></li>
<li>Oracle:

<pre><code>33221100554477668899AABBCCFFEEFF
</code></pre></li>
</ul>

So it should be fairly easy to write code to switch round the relevant bytes. (I'm pretty sure I wrote some code to do this in a previous job, in fact.)

To switch round the bytes, you'll just want to call <code>Guid.ToByteArray()</code> and <code>new Guid(byte[])</code> to get back to a <code>Guid</code>.

EDIT: As it happens, the switch-round above is exactly what the <code>Guid</code> constructor does when you pass it a byte array:

<pre><code>using System;
using System.Linq;

class Test
{
 static void Main()
 {
 byte[] bytes = Enumerable.Range(0, 16)
 .Select(x =&gt; x * 16 + x)
 .Select(x =&gt; (byte) x)
 .ToArray();

 Console.WriteLine(BitConverter.ToString(bytes).Replace("-", ""));
 Console.WriteLine(new Guid(bytes).ToString().Replace("-", ""));
 }
}
</code></pre>

Prints:

<pre><code>00112233445566778899AABBCCDDEEFF
33221100554477668899aabbccddeeff
</code></pre>

That may well make it considerably simpler to perform the switching... how were you getting hold of the values to start with? Is it just "how they're displayed in Oracle"?

EDIT: Okay, here are a couple of conversion functions - if you've got the data as text, they'll convert each way...

<pre><code>using System;
using System.Linq;

class Test
{
 static void Main()
 {
 string oracle = "329DD817216CD6429B989F5201288DBF";
 string dotNet = "17D89D326C2142D69B989F5201288DBF";

 Console.WriteLine(oracle == DotNetToOracle(dotNet));
 Console.WriteLine(dotNet == OracleToDotNet(oracle));
 }

 static string OracleToDotNet(string text)
 {
 byte[] bytes = ParseHex(text);
 Guid guid = new Guid(bytes);
 return guid.ToString("N").ToUpperInvariant();
 }

 static string DotNetToOracle(string text)
 {
 Guid guid = new Guid(text);
 return BitConverter.ToString(guid.ToByteArray()).Replace("-", "");
 }

 static byte[] ParseHex(string text)
 {
 // Not the most efficient code in the world, but
 // it works...
 byte[] ret = new byte[text.Length / 2];
 for (int i = 0; i &lt; ret.Length; i++)
 {
 ret[i] = Convert.ToByte(text.Substring(i * 2, 2), 16);
 }
 return ret;
 }

}
</code></pre>

blocks|key|828467|text|只要用你的标准GUID在.NET.|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|828468|当您想在Oracle中插入一些GUID时，只需调用Guid.ToString+(+"N")并将该字符串提供给Oracle+(在本例中，param名称为MyNETVAL)：|828469|INSERT+INTO+MyTable+(+MyRAWCol)
SELECT+HEXTORAW+(SUBSTR+(MyNETVal,+6,+2)+%7C%7C+SUBSTR+(MyNETVal,+4,+2)+%7C%7C+SUBSTR+(MyNETVal,+2,+2)+%7C%7C+SUBSTR+(MyNETVal,+0,+2)+%7C%7C+SUBSTR+(MyNETVal,+10,+2)+%7C%7C+SUBSTR+(MyNETVal,+8,+2)+%7C%7C+SUBSTR+(MyNETVal,+14,+2)+%7C%7C+SUBSTR+(MyNETVal,+12,+2)+%7C%7C+SUBSTR+(MyNETVal,+16,+16))+FROM+DUAL;|code-block|syntax|javascript|828470|当从Oracle读取RAW时，可以使用：|828471|SELECT+
SUBSTR+(HexV,+6,+2)+%7C%7C+SUBSTR+(HexV,+4,+2)+%7C%7C+SUBSTR+(HexV,+2,+2)+%7C%7C+SUBSTR+(HexV,+0,+2)+%7C%7C+SUBSTR+(HexV,+10,+2)+%7C%7C+SUBSTR+(HexV,+8,+2)+%7C%7C+SUBSTR+(HexV,+14,+2)+%7C%7C+SUBSTR+(HexV,+12,+2)+%7C%7C+SUBSTR+(HexV,+16,+16)+AS+MyNETVal
FROM+(SELECT+RAWTOHEX+(MyRAWCol)+HexV+FROM+MyTable);|828472|然后，可以将返回的MyNETVal输入到new+Guid+(MyNETVal)中。|828473|这样，您的代码总是处理.NET格式，字节切换发生在Oracle中.您不使用转换代码来优化您的代码，并且可以在切换到其他DB时保持代码相同--只需更改SQL，您就可以启动并运行.SQL可以与其他DB一起变得更简单，因为其中一些数据库遵循Windows的GUID格式.|828474|entityMap^0|7|4|0|F|4|P|K|23|8|0|0|A|3|0|0|9|8|K|J|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@$9|10|A|11|B|C]|$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|16|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|1A|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1B|8|@$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1G|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1H|8|@]|D|@]|E|$]]]|V|$]]

Just use always your standard <code>GUID</code> in .NET...

When you want to insert some <code>GUID</code> into Oracle you just call <code>Guid.ToString ( "N")</code> and feed that string to Oracle (in this example the param name is <code>MyNETVAL</code>):

<pre><code>INSERT INTO MyTable ( MyRAWCol)
SELECT HEXTORAW (SUBSTR (MyNETVal, 6, 2) || SUBSTR (MyNETVal, 4, 2) || SUBSTR (MyNETVal, 2, 2) || SUBSTR (MyNETVal, 0, 2) || SUBSTR (MyNETVal, 10, 2) || SUBSTR (MyNETVal, 8, 2) || SUBSTR (MyNETVal, 14, 2) || SUBSTR (MyNETVal, 12, 2) || SUBSTR (MyNETVal, 16, 16)) FROM DUAL;
</code></pre>

When you read a <code>RAW</code> from Oracle you use: 

<pre><code>SELECT 
SUBSTR (HexV, 6, 2) || SUBSTR (HexV, 4, 2) || SUBSTR (HexV, 2, 2) || SUBSTR (HexV, 0, 2) || SUBSTR (HexV, 10, 2) || SUBSTR (HexV, 8, 2) || SUBSTR (HexV, 14, 2) || SUBSTR (HexV, 12, 2) || SUBSTR (HexV, 16, 16) AS MyNETVal
FROM (SELECT RAWTOHEX (MyRAWCol) HexV FROM MyTable);
</code></pre>

Then you can feed the returned <code>MyNETVal</code> into <code>new Guid (MyNETVal)</code>.

This way your code always deals with the .NET format and the byte switching occurs in the Oracle-DB... you don't polute your code with conversion code and can keep the code code the same when switchig to other DBs - just change the SQL and you are up and running... the SQL could get simpler with other DBs because some of them follow the GUID format of Windows...

blocks|key|2663884|text|如果需要将GUID从PL/SQL转换为原始，则可以使用以下函数：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2663885|/*
++++CONVERT+a+GUID+FORMAT+in+RAW(16)
++++EX:
++++++++guid++++=+88c6a267-65d2-48d6-8da2-6f45e2c22726
++++++++raw+++++=+67A2C688D265D6488DA26F45E2C22726
*/
FUNCTION+GuidToRaw(+guid+IN+VARCHAR2+)+RETURN+RAW
IS
++++ret+++++++++RAW(16);
++++guidHex+++++VARCHAR2(64);
BEGIN

++++guidHex+:=+SUBSTR+(guid,+7,+2);
++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+5,+2)+);
++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+3,+2)+);
++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+1,+2)+);

++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+12,+2)+);
++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+10,+2)+);

++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+17,+2)+);
++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+15,+2)+);

++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+20,+2)+);
++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+22,+2)+);

++++guidHex+:=+CONCAT(+guidHex,+SUBSTR+(guid,+25,+12)+);

++++ret+:=+HEXTORAW(+guidHex+);

++++return+ret;

end;|code-block|syntax|javascript|2663886|entityMap^0|5|4|A|6|J|2|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|L|$]]

If you need to convert a GUID to RAW from PL/SQL can use this function:

<pre><code>/*
 CONVERT a GUID FORMAT in RAW(16)
 EX:
 guid = 88c6a267-65d2-48d6-8da2-6f45e2c22726
 raw = 67A2C688D265D6488DA26F45E2C22726
*/
FUNCTION GuidToRaw( guid IN VARCHAR2 ) RETURN RAW
IS
 ret RAW(16);
 guidHex VARCHAR2(64);
BEGIN

 guidHex := SUBSTR (guid, 7, 2);
 guidHex := CONCAT( guidHex, SUBSTR (guid, 5, 2) );
 guidHex := CONCAT( guidHex, SUBSTR (guid, 3, 2) );
 guidHex := CONCAT( guidHex, SUBSTR (guid, 1, 2) );

 guidHex := CONCAT( guidHex, SUBSTR (guid, 12, 2) );
 guidHex := CONCAT( guidHex, SUBSTR (guid, 10, 2) );

 guidHex := CONCAT( guidHex, SUBSTR (guid, 17, 2) );
 guidHex := CONCAT( guidHex, SUBSTR (guid, 15, 2) );

 guidHex := CONCAT( guidHex, SUBSTR (guid, 20, 2) );
 guidHex := CONCAT( guidHex, SUBSTR (guid, 22, 2) );

 guidHex := CONCAT( guidHex, SUBSTR (guid, 25, 12) );

 ret := HEXTORAW( guidHex );

 return ret;

end;
</code></pre>

blocks|key|2663931|text|在从Oracle存储和读取Guids时，我也遇到了同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2663932|Jon的答案对于查询是正确的，但是如果您的应用程序需要从Oracle存储和读取Guid，请使用以下线程中的FlipEndian函数：|2663933|.NET+Native+GUID+conversion|offset|length|2663934|Byte[]+rawBytesFromOracle;
Guid+dotNetGuid+=+new+Guid(rawBytesFromOracle).FlipEndian();|code-block|syntax|javascript|2663935|只有在从Oracle读取数据时才需要翻转。|2663936|当写入Oracle时，请正常使用Guid.ToByteArray()。|2663937|我花了太多的时间来完成这个简单的任务。|2663938|史蒂夫|2663939|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/8064648/net-native-guid-conversion?lq=1^0|0|0|0|R|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@$F|15|G|16|1|17]]|A|$]]|$1|H|3|I|5|J|7|18|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

I just had this same issue when storing and reading Guids from Oracle.

Jon's answer is correct for querying but if your app needs to store and read Guids from Oracle, use the FlipEndian function from this thread:

<a href="https://stackoverflow.com/questions/8064648/net-native-guid-conversion?lq=1">.NET Native GUID conversion</a>

<pre><code>Byte[] rawBytesFromOracle;
Guid dotNetGuid = new Guid(rawBytesFromOracle).FlipEndian();
</code></pre>

The flip is only required when reading back from Oracle. 

When writing to Oracle use Guid.ToByteArray() as normal.

I spent TOO much time trying to get this simple task accomplished.

Steve

I'm having difficulties manually debugging an .NET application where the Guid values differ from .NET to Oracle.

<ul>
<li>Where C# reads:
<ul>
<li><code>17D89D326C2142D69B989F5201288DBF</code></li>
</ul></li>
<li>Oracle reads: 
<ul>
<li><code>329DD817216CD6429B989F5201288DBF</code></li>
</ul></li>
</ul>

How would I be able to manually debug, i.e., from C#'s GUID be able to paste that value in an oracle query and get the correct results (and viceversa)?

Convert from Oracle's RAW(16) to .NET's GUID

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我在手动调试.NET应用程序时遇到困难，Guid值在.NET和Oracle之间存在差异。17D89D326C2142D69B989F5201288DBF  C# reads：​Oracle读取：- `329DD817216CD6429B989F5201288DBF`​我如何能够手动调试，即从C#的GUID中粘贴该值到o...

问从Oracle的RAW(16)转换为.NET的GUID
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Oracle的RAW(16)转换为.NET的GUIDEN