umbraco Forum » umbraco Core » Bugs and issues » What is the story of ConvertGuid function, and do I really need it?

What is the story of ConvertGuid function, and do I really need it? Options
Previous Topic · Next Topic
GlennSorensen
Posted: Wednesday, April 23, 2008 11:37:52 PM
Rank: Newbie

Joined: 4/18/2008
Posts: 3
Hi all,

I'm having some issues deploying my website to my hosting provider based on the MySQL datalayer well underway. Se further info on my issue here:
http://forum.umbraco.org/yaf_postsm23194_MySQL-install-issue-regarding-ConvertGuid-function.aspx

In short I'm not able to create the ConvertGuid function on my hosted MySQL database.

The function looks like this:
CREATE FUNCTION ConvertGuid(guid CHAR(37)) RETURNS CHAR(37) RETURN guid;

As far as I can se, the function is used in the database create script, but I can't seem to find any references/calls to it elsewhere in the source code.

So this raises the question: What is the story of ConvertGuid function, and do I really need it?

/Glenn
Back to top
 
Ruben
Posted: Monday, May 12, 2008 11:48:29 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 111
Location: Belgium
Hi Glenn,

The ConvertGuid is not used anymore. I created this when I started the datalayer, to provide a conversion function for GUIDs. I was hoping to store them as a byte array or something, since MySQL doesn't have a GUID datatype like SQL Server has. However, it turned out practically impossible to rely on proper data type conversion. So the ConvertGuid function was changed into a "pass-through" function, which of course looks kinda stupid. But the idea to leave it there was: if one day we're going to use it again, we don't have to change the whole data installation script.

So, you can delete it safely and simply remove all occurrences, it doesn't do anything.

Regards,

Ruben
Umbraco Core Team Developer | Working on VistaDB support | LinkedIn
Back to top
 
Users browsing this topic
Guest

umbraco Forum » umbraco Core » Bugs and issues » What is the story of ConvertGuid function, and do I really need it?


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.