Krathos Morpheus
Legion Infernal
|
Posted - 2011.07.02 18:37:00 -
[5]
Originally by: Thart
Originally by: Thart Devs heavily changed data types in the database. And my app doesn't work with it. Seems like a great piece of work waiting for me this weekend ;)
I was wrong. Seems like this conversion is inaccurate. Compare it with previous conversions to see the difference.
What do you mean? SQLite have very few datatypes compared to MSsql, in reality it has only five storage classes. I guess the converter may simplify some of the names but in the end the ground types are the same and should not break your software. Am I wrong? If so please explain how so, I'm only recently learning all this and would like to know, I could also poke the software author a little and have a better conversion next time if it's important. In my case is the get method that specifies the data type.
|
Thart
U.K.R.A.I.N.E SOLAR FLEET
|
Posted - 2011.07.02 18:49:00 -
[6]
Originally by: Krathos Morpheus What do you mean? SQLite have very few datatypes compared to MSsql, in reality it has only five storage classes. I guess the converter may simplify some of the names but in the end the ground types are the same and should not break your software. Am I wrong? If so please explain how so, I'm only recently learning all this and would like to know, I could also poke the software author a little and have a better conversion next time if it's important. In my case is the get method that specifies the data type.
Yes, sqlite has only 5 internal datatypes. But each of these types can be used with different aliases. And these aliases can be important for the caller.
For instance, if you "describe" invTypes table you will see that typeID has "integer" type. In previous conversion it was "int".
SQLiteDataReader treats "integer" type as 64-bit and "int" as 32-bit.
Your invTypes:
Quote: -- Describe INVTYPES CREATE TABLE [invTypes] ( "typeID" integer NOT NULL, "groupID" smallint, "typeName" nvarchar(100) COLLATE NOCASE, "description" nvarchar(3000), "graphicID" integer, "radius" float, "mass" float, "volume" float, "capacity" float, "portionSize" integer, "raceID" smallint, "basePrice" numeric, "published" bit, "marketGroupID" smallint, "chanceOfDuplicating" float, "iconID" integer, PRIMARY KEY ([typeID]) )
Expected invTypes:
Quote: -- Describe INVTYPES CREATE TABLE "invTypes" ( "typeID" int(11) NOT NULL, "groupID" smallint(6) DEFAULT NULL, "typeName" varchar(100) DEFAULT NULL, "description" varchar(3000) DEFAULT NULL, "graphicID" smallint(6) DEFAULT NULL, "radius" double DEFAULT NULL, "mass" double DEFAULT NULL, "volume" double DEFAULT NULL, "capacity" double DEFAULT NULL, "portionSize" int(11) DEFAULT NULL, "raceID" tinyint(3) DEFAULT NULL, "basePrice" double DEFAULT NULL, "published" tinyint(1) DEFAULT NULL, "marketGroupID" smallint(6) DEFAULT NULL, "chanceOfDuplicating" double DEFAULT NULL, "iconID" smallint(6) DEFAULT NULL, PRIMARY KEY ("typeID") )
----------------------------------------- EVE Mentat - true trade tool |