Truncation is the term for limiting the number of digits right of the decimal point, by discarding the least significant ones.
Questions tagged [truncated]
256 questions
0
votes
1 answer
format of the numbers in json-c
I have numbers much lower than zero (p.e. 1.34e-14) that I want to add to a json object. For this, I am using this code:
smallnumber=1.34e-14;
struct json_object *pointj=json_object_new_object();
json_object_object_add(pointj,"par",…

user1046064
- 3
- 1
- 4
0
votes
1 answer
Mysql timestamp Data truncated for column
I'm attempting to use python to insert a timestamp into column created_by of a mysql db.
Here is my database table setup..
CREATE TABLE temps (
temp1 FLOAT, temp2 FLOAT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
temp1 and temp2 and…

user2782497
- 31
- 1
- 7
0
votes
1 answer
SQL Update error: spaces truncate strings
I'm having a problem with sql.
When I try updating like this:
UPDATE Event SET name = 'bla bla bla' WHERE id = 2
It gives me this error:
String or binary data would be truncated. The statement has been terminated.
However, when I try updating…

Matheus Simon
- 668
- 11
- 34
0
votes
1 answer
How to solve Data truncated?
I insert the data from CSV file into MySql database, especially into one table.
I use CSVRead, and the CSV file format is :
ts,val
2013-03-31T23:45:00-04:00 New_York,10
And the table is hisdata(ts, val).
Here is my code:
try{
try {
…

Eric
- 1,271
- 4
- 14
- 21
0
votes
0 answers
Android - Webview truncates string
I have a Webview where I am trying to show this string:
"---@%-@%%#:-=%@+=%-#@##%@%--.....-=.-=:-:.........=----::::::::=---:::::::::::::.............................................::::.........................................-#+ ."
However, the…

arpo
- 13
- 2
0
votes
2 answers
Truncated Response for Web page with 0x00 character
I write a program wich download web pages. It works fine for most of web pages but i have found some pages where it doesn't work.
These pages contains 0x00 characters.
I'm able to read page content until this character, but not the content after.
I…

Euyeusu
- 1
- 1
0
votes
1 answer
Cursor column value randomly getting truncated?
I have a cursor in an oracle stored procedure that randomly truncates the value in one of the returned columns.
I cannot see any pattern to this, sometimes it works other times it just truncates the value to 1 char long.
This is the cursor:
CURSOR…

mcquaim
- 159
- 7
- 15
0
votes
3 answers
Access SQL/query has truncated field at 25 characters?
I have this query in Access:
SELECT a.title, a.init, a.name, l.User AS CreatedBy,
IIf(IsNull(l.Time),Null,DateAdd("s",l.Time,#3/1/1980#)) AS CreatedAt
FROM (Reports AS a LEFT JOIN
(SELECT id, Min([time]) AS Mintime FROM AuditLog…

JBurace
- 5,123
- 17
- 51
- 76
0
votes
0 answers
Like box bottom border truncated when less than height < 425px
This issue was raised and closed last year, but I am still finding it happening.
If you specify a height of less than 424px, the bottom of the likebox is truncated so that you cannot see the bottom border. If it's much less than 400px, you cannot…
0
votes
1 answer
GRAILS- Image corrupt or truncated
im getting this error "image corrupt or truncated" on FF console when I try to display an image stored in my database. I´m using Grails and Hibernate.
I just want to display a user´s profile picture in my gsp page.
My domain class User has an…

user1286733
- 3
- 1
0
votes
1 answer
How to tell if ultragrid text has been truncated
We are using infragistics ultragrid to present data to the user. if the user modifies the width of a column, I need to be able to tell if the data is truncated so that I can adjust the output properly when exporting the data into pdf. We want to…

Currie Dail
- 33
- 6
0
votes
0 answers
How to generate a random field with truncated marginal distributions?
Is there an R package or functions which can generate a random field with truncated distributions?
I am trying to simulate a lognormal spatial random field but I need the simulated value in a certain range. So I need some easy to use functions to…

Zhenglei
- 988
- 1
- 10
- 21
0
votes
1 answer
saving a long string using cPickle - saved variable is truncated
I am dumping a string of 0s and 1s of length 4807100171 into a pickle file because I had previous trouble with bitarray and wanted to see if pickle could be a solution to my problem. However, after I load it, it now is of length 512132875.
Why is…

macrocosme
- 473
- 7
- 24
0
votes
2 answers
PHP function return value nested array removed
I have a function that builds a collection of user objects from the database:
public static function GetUsersByGroup($instanceID, $groupID)
{
$col = null;
if($groupID != null)
{
$col =…

Gavin
- 2,153
- 2
- 25
- 35
0
votes
1 answer
Entity Framework String would be truncated Error
I have a flat-file SQL Server database. I'm trying to insert info into the table but I keep getting "String or binary data would be truncated" errors every time I run it. ALL of my text fields are nvarchar(max), but it still throws the error and I…

toadzky
- 261
- 3
- 12