> Hello all,

> i was just playing with gen_uuid() in firebird 2.1.2

> i did the following
> add a field to a existing table with a little more then 2 mio record
> update the table with the uuids
> run a select on it

> select strlen(z.guid16), count(*) from rechnungszeile z group by 1

> should the result not be a stringlength of 16 for all ?

found it , if i use the new char_length built in function instead of
the supplied udf strlen then the result is as expected

> Result
> #STRLEN COUNT
> 0 7917
> 1 7787
> 2 7856
> 3 7698
> 4 7836
> 5 7836
> 6 7749
> 9 7716
> 10 7799
> 11 7651
> 12 7602
> 13 7461
> 14 7523
> 15 7567
> 16 1923177


>

--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...