View Single Post
Old 2016-08-21, 20:00   #1109
GP2
 
GP2's Avatar
 
Sep 2003

1010000101002 Posts
Default

Quote:
Originally Posted by Madpoo View Post
I imagine for the most part it would be an easy enough transition since SQL can typically do implicit casts between them and won't complain, but there would be issues in boolean operations where varchar <> nvarchar so we'd have to dig into it more to make sure we're good.
How normalized is the database? Does the Public Name (from http://www.mersenne.org/update/ ) really get stored in more than one place, or get compared against, or used for purposes other than display? I would have thought that the V5UserID from prime.txt or the SrvrUID from local.txt would be the key fields in the tables.

Last fiddled with by GP2 on 2016-08-21 at 20:02
GP2 is offline   Reply With Quote