| Subject | AW: AW: [firebird-support] binary or string? |
|---|---|
| Author | Alexander Gräf |
| Post date | 2004-12-11T23:47:35Z |
> -----Ursprüngliche Nachricht-----If there would be any difference, the Int64 would be faster. In indices this would not make a big difference anyway, even if there wasnt any index compression.
> Von: Ann W. Harrison [mailto:aharrison@...]
> Gesendet: Samstag, 11. Dezember 2004 23:53
> An: firebird-support@yahoogroups.com; firebird-support@yahoogroups.com
> Betreff: Re: AW: [firebird-support] binary or string?
>
But direct comparisons are needed with natural joins I guess, and the biggest problem is the disability to write direct queries, because the binary data can only be passed via programmatic paramaters. I guess there are cases in which CHAR(xy) data will be copied bytewise, where Int64 will be copied directly, without memcpy or a similar function.
It's also a pitty there is no native UUID data type (or 128bit numeric data type that could be misused) available. Any plans to add this?
Regards, Alex