pcsoft.us.windevCopyright 2026, PC SOFT20 Dec 2017 10:47:26 Z19 Dec 2017 17:41:21 ZHello, I am wondering if there is a best practice on how to store GUID's in an HFSQL table. Two methods come to mind: - store the 32 characters in a normal string or - convert it into a 16 byte ASCII string Any of you using this? Glad for comments/suggestions Ulrich30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables/read.awpBest practice storing GUID's in tablesmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)fromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63739/read.awp20 Dec 2017 10:47:26 ZHi Ulrich, as I have no idea how frequently a GUID would contain a binary zero, I suppose that part COULD work, but I would…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63739/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63739/read.awpBest practice storing GUID's in tablesRe: Best practice storing GUID's in tablesUlrichpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63734/read.awp19 Dec 2017 22:58:19 ZHi Fabrice, I thought you might reply as you are the one who gave me the GUID in the first place. Concerning the potential o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63734/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63734/read.awpBest practice storing GUID's in tablesRe: Best practice storing GUID's in tablesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63732/read.awp19 Dec 2017 18:39:39 ZHi I'm storing them as a 24bytes ansi string, encoded in base64... As for transforming them in binary (which is what I thi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63732/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63731-best-practice-storing-guid-tables-63732/read.awpBest practice storing GUID's in tablesRe: Best practice storing GUID's in tables