Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Krathos Morpheus
Legion Infernal
|
Posted - 2011.07.02 11:05:00 -
[1]
|
Thart
U.K.R.A.I.N.E SOLAR FLEET
|
Posted - 2011.07.02 14:04:00 -
[2]
Thank you! Downloading and going to test it. ----------------------------------------- EVE Mentat - true trade tool |
Thart
U.K.R.A.I.N.E SOLAR FLEET
|
Posted - 2011.07.02 15:21:00 -
[3]
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 ;)
So I understand why they didn't relese DB in time. Predict a new wave of whine :)
As software dev I understand importance of such changes but I think they must be pre-announced. ----------------------------------------- EVE Mentat - true trade tool |
Thart
U.K.R.A.I.N.E SOLAR FLEET
|
Posted - 2011.07.02 17:43:00 -
[4]
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. ----------------------------------------- EVE Mentat - true trade tool |
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 |
Krathos Morpheus
Legion Infernal
|
Posted - 2011.07.02 18:53:00 -
[7]
I see... so some software uses the aliases to establish the data type. Thanks.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |