Re: [Firebird-net-provider] System.Guid
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 a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
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 69, FI-02540 Kylmälä Tel. : +358 (0) 400 27 25 18 E- mail : n...@tetrasys.fi -Message d'origine- De : Jiří Činčura [mailto:j...@cincura.net] Envoyé : mardi 20 janvier 2015 07:39 À : For users and developers of the Firebird .NET providers Objet : Re: [Firebird-net-provider] System.Guid 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 a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- 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. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
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 -- 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. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] System.Guid
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:
System.String ):System.Int32;
Begin
var sqlCommand: StringBuilder := new StringBuilder;
sqlCommand.Append('INSERT INTO RM_CUSTOMERS_LINK_GUID ( GUID, GUID36)');
sqlCommand.Append(' VALUES ( @GUID, @GUID36)');
sqlCommand.Append(' ;');
var arParams: array of FbParameter := new FbParameter[2];
arParams[0] := new FbParameter('@GUID',FbDbType.Guid);
arParams[0].Direction := ParameterDirection.Input;
arParams[0].Charset := FbCharset.Octets ;
arParams[0].Value := GUID;
arParams[1] := new FbParameter('@GUID36',FbDbType.VarChar, 36);
arParams[1].Direction := ParameterDirection.Input;
arParams[1].Charset := FbCharset.Iso8859_1 ;
arParams[1].Value := GUID36;
var rowsAffected: System.Int32 :=
FBSqlHelper.ExecuteNonQuery(getdestination, sqlCommand.ToString(), arParams);
exit rowsAffected;
end;
var UserGuid : System.Guid := System.Guid.NewGuid;
insert_RM_CUSTOMERS_LINK_GUID(UserGuid,UserGuid.ToString);
result :
GUID
GUID36
UUID
ê„þET +Mƒ $T•— È
45fe84ea-0b54-4d2b-83a0-2454959713c8
EA84FE45-540B-2B4D-83A0-2454959713C8
Why ?
Norbert Saint Georges
TetraSys Oy
Bergantie 69, FI-02540 Kylmälä
Tel. : +358 (0) 400 27 25 18
E- mail : n...@tetrasys.fi mailto:taru.kaukova...@tetrasys.eu
--
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.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
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. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] System.Guid
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•— È 45fe84ea-0b54-4d2b-83a0-2454959713c8 EA84FE45-540B-2B4D-83A0-2454959713C8 The two of them, GUID.tostring et uuid_to_char(GUID) should give the same string in result. Thanks, Norbert Saint Georges TetraSys Oy Bergantie 69, FI-02540 Kylmälä Tel. : +358 (0) 400 27 25 18 E- mail : n...@tetrasys.fi mailto:taru.kaukova...@tetrasys.eu -Message d'origine- De : Jiří Činčura [mailto:j...@cincura.net] Envoyé : lundi 19 janvier 2015 21:38 À : For users and developers of the Firebird .NET providers Objet : Re: [Firebird-net-provider] System.Guid 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. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net mailto:Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- 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. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
