sqlite3 -Infinity value in Float fieldSelect column from ALL tablesSQLite3 simple database design...
Resorting data from a multidimensional list
Protagonist constantly has to have long words explained to her. Will this get tedious?
How do I make my single-minded character more interested in the main story?
Is the percentage symbol a constant?
How to make transparent background from pdf to png
Did ancient Germans take pride in leaving the land untouched?
What is formjacking?
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?
Why is Shelob considered evil?
Is it possible to narrate a novel in a faux-historical style without alienating the reader?
Missing a connection and don't have money to book next flight
Does しかたない imply disappointment?
Is the tritone (A4 / d5) still banned in Roman Catholic music?
What is an explicit bijection in combinatorics?
Converting numbers to words - Python
When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?
Partial derivative with respect to three variables
What does "south of due west" mean?
Trying to make a 3dplot
bash aliases do not expand even with shopt expand_aliases
Graphical modeler calculator missing in QGIS3
C++ range based loop with special case for first item?
Are one-line email responses considered disrespectful?
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♦ 8 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♦ 8 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♦ 8 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♦ 8 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