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


--
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

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 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

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 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

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•— È

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  

> -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  

> ___

> 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

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.
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

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: 
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  

 

--
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