sqlite3 -Infinity value in Float fieldSelect column from ALL tablesSQLite3 simple database design...
Integer but not Laurent sequences
How many copper coins fit inside a cubic foot?
Why does this quiz question say that protons and electrons do not combine to form neutrons?
Why is Shelob considered evil?
Have the UK Conservatives lost the working majority and if so, what does this mean?
Identical projects by students at two different colleges: still plagiarism?
How do I avoid the "chosen hero" feeling?
What is an explicit bijection in combinatorics?
Sets which are both Sum-free and Product-free.
Can an attached stirge deal no more than 10 HP of damage before it detaches?
Is there any danger of my neighbor having my wife's signature?
Will the duration of traveling to Ceres using the same tech developed for going to Mars be proportional to the distance to go to Mars or not?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Minimum Viable Product for RTS game?
Are all power cords made equal?
Is there a configuration of the 8-puzzle where locking a tile makes it harder?
Why don't programs completely uninstall (remove all their files) when I remove them?
How to transport 10,000 terrestrial trolls across ocean fast?
I am a loser when it comes to jobs, what possibilities do I have?
Why do single electrical receptacles exist?
Can a Way of Shadow Monk use Shadow Step to teleport to a dark ceiling and then body slam another creature?
Why can all solutions to the simple harmonic motion equation be written in terms of sines and cosines?
Trying to make a 3dplot
Does しかたない imply disappointment?
sqlite3 -Infinity value in Float field
Select column from ALL tablesSQLite3 simple database design questionUpdate previous value fieldImproving `GROUP BY` query performance in sqlite3Possible SQLite bug?number field in varchar2 fieldSQLite3 foreign key mismatchinvestigate contents of a sqlite3 fileGroup values: CASE text, ELSE field valueSqlite3 - Data type size restrictions or how to migrate an Oracle float(126)?
I am converting Oracle tables into a sqlite3 Database and stuck at the "-Infinity"-value in a float field.
The snippet of the Oracle "Create Table" statement is
"X1" FLOAT(126)
How do I convert the "-Infinity" value correctly into a sqlite3 table?
oracle sqlite
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am converting Oracle tables into a sqlite3 Database and stuck at the "-Infinity"-value in a float field.
The snippet of the Oracle "Create Table" statement is
"X1" FLOAT(126)
How do I convert the "-Infinity" value correctly into a sqlite3 table?
oracle sqlite
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
How exactly are you doing the conversion? What is the problem with the current conversion?
– CL.
May 4 '18 at 8:04
add a comment |
I am converting Oracle tables into a sqlite3 Database and stuck at the "-Infinity"-value in a float field.
The snippet of the Oracle "Create Table" statement is
"X1" FLOAT(126)
How do I convert the "-Infinity" value correctly into a sqlite3 table?
oracle sqlite
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
I am converting Oracle tables into a sqlite3 Database and stuck at the "-Infinity"-value in a float field.
The snippet of the Oracle "Create Table" statement is
"X1" FLOAT(126)
How do I convert the "-Infinity" value correctly into a sqlite3 table?
oracle sqlite
oracle sqlite
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
asked May 3 '18 at 12:13
fetch_execute_breakfetch_execute_break
124
124
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
How exactly are you doing the conversion? What is the problem with the current conversion?
– CL.
May 4 '18 at 8:04
add a comment |
How exactly are you doing the conversion? What is the problem with the current conversion?
– CL.
May 4 '18 at 8:04
How exactly are you doing the conversion? What is the problem with the current conversion?
– CL.
May 4 '18 at 8:04
How exactly are you doing the conversion? What is the problem with the current conversion?
– CL.
May 4 '18 at 8:04
add a comment |
1 Answer
1
active
oldest
votes
I chose "REAL" as data type and just stored "-Infinity" inside it. Seems to work.
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f205693%2fsqlite3-infinity-value-in-float-field%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I chose "REAL" as data type and just stored "-Infinity" inside it. Seems to work.
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
add a comment |
I chose "REAL" as data type and just stored "-Infinity" inside it. Seems to work.
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
add a comment |
I chose "REAL" as data type and just stored "-Infinity" inside it. Seems to work.
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
I chose "REAL" as data type and just stored "-Infinity" inside it. Seems to work.
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
answered May 8 '18 at 14:21
fetch_execute_breakfetch_execute_break
124
124
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f205693%2fsqlite3-infinity-value-in-float-field%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
How exactly are you doing the conversion? What is the problem with the current conversion?
– CL.
May 4 '18 at 8:04