Re: [Firebird-net-provider] System.Guid

2015-01-19 Thread Jiří Činčura
Guid is opaque value. Interpretation in string is just a visual representation. -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering

Re: [Firebird-net-provider] System.Guid

2015-01-19 Thread Norbert Saint Georges
Of course, but the same interpretation regardless of the system. System.Guid.ToString is not the same as select uuid_to_char (guid). in an application that mixes char(16) character set octets and varchar(36) is not possible currently, why? Norbert Saint Georges TetraSys Oy Bergantie

Re: [Firebird-net-provider] System.Guid

2015-01-19 Thread Jiří Činčura
in an application that mixes char(16) character set octets and varchar(36) is not possible currently, why? It's simple. Don't do it. You're mixing binary data with string. Depending on LE or BE system you might get different result. -- Mgr. Jiří Činčura Independent IT Specialist

[Firebird-net-provider] System.Guid

2015-01-19 Thread Norbert Saint Georges
Hello I have a problem with GUIDs below, describe CREATE TABLE RM_CUSTOMERS_LINK_GUID ( GUIDCHAR(16) CHARACTER SET OCTETS, GUID36 VARCHAR(36), UUIDCOMPUTED BY (uuid_to_char(guid)) ); method MainForm.insert_RM_CUSTOMERS_LINK_GUID( GUID: System.Guid; GUID36:

Re: [Firebird-net-provider] System.Guid

2015-01-19 Thread Jiří Činčura
And what’s not clear? -- Mgr. Jiří Činčura Independent IT Specialist -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn.

Re: [Firebird-net-provider] System.Guid

2015-01-19 Thread Norbert Saint Georges
Why is the translation of the guid with uuid_to_char(guid) (field UUID) NOT the same as guid.tostring (field guid36) var UserGuid : System.Guid := System.Guid.NewGuid; insert_RM_CUSTOMERS_LINK_GUID(UserGuid,UserGuid.ToString); GUID GUID36 UUID ê„þET +Mƒ $T•— È