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
4
votes
3 answers
Trouble with GROUP_CONCAT and Longtext in MySQL
The SQL...
UPDATE Threads t
SET t.Content = (
SELECT GROUP_CONCAT(a.Content ORDER BY a.PageID SEPARATOR '')
FROM MSarticlepages a
WHERE a.ArticleID = t.MSthreadID GROUP BY a.ArticleID
)
As you can see it takes all of…
Iwasakabukiman
- 1,453
- 4
- 15
- 17
4
votes
3 answers
How can I see if MySQL truncated a field during an Update using Perl DBI
When I run this Update SQL in DBVis, I get an error (Data truncation: Data too long for column 'Description' at row 1).
However, in Perl (DBI), this is not giving me an error I am guessing because the record actually was updated with the truncated…
Jeremey
- 1,456
- 3
- 13
- 19
4
votes
2 answers
Why is my data being truncated? Warning | 1265 | Data truncated for column
I tried adding NULL to both date_of_birth and date_of_death, but that didn't help. Why is data being truncated? (especially because there isn't any data at the moment...)
Also, I don't understand warning 1261 at all. Row 5 is no different from rows…
Bleakley
- 653
- 2
- 9
- 19
4
votes
4 answers
CXF JAVA message Truncated
Good afternoon,
I'm running Apache Tomcat 7.0.57 under GNU/Linux CentOS 6.6 Final and with this…
Jose Monreal Bailey
- 461
- 1
- 5
- 12
4
votes
1 answer
How do I make ABCPdf to automatically write to a new page when text requires more than 1 page?
I deal with dynamic input text, so the pages should be dynamically created. If page 1 is already full, it should write to a new page, so it means I can have page 2, page 3 and so on depending on the data processed.
Currently, my text is truncated.…
maximumride
- 311
- 1
- 4
- 18
4
votes
2 answers
Truncating 64-bit IEEE doubles to 61-bits in a safe fashion
I am developing a programming language, September, which uses a tagged variant type as its main value type. 3 bits are used for the type (integer, string, object, exception, etc.), and 61 bits are used for the actual value (the actual integer,…
Jakub Wasilewski
- 2,916
- 22
- 27
4
votes
0 answers
mssql_bind in PHP truncates string
I'm using FreeTDS to connect and work with a SQL Server 2008 database from PHP 5.3.15 on Linux. I have a column in this database that has a datatype of VARCHAR(MAX).
Unfortunately, I'm having trouble setting the value of the column via mssql_bind()…
tptcat
- 3,894
- 2
- 32
- 51
3
votes
2 answers
MATLAB symbolic state space matrix is too large
I am trying to generate a transfer function from the state space matrices that I have.
The problem is that the matrices have variables and not numeric values so I have to use symbolic variables in Matlab.
So I started with:
A =
[ -a0, 0, 0, …
CMacDady
- 227
- 2
- 8
3
votes
0 answers
sql.Query truncated or incomplete results
I've the following code:
const qInstances = `
SELECT
i.uuid,
i.host,
i.hostname
FROM
db.instances AS i
WHERE
i.deleted_at IS NULL
GROUP BY i.uuid;
`
...
instancesMap := make(map[string]*models.InstanceModel)
instances :=…
happygopher
- 111
- 1
- 7
3
votes
1 answer
How to set tooltip ONLY on truncated cell dynamically
My goal is to display a tooltip on cells where the text is truncated at launch, but also during runtime, which means that if a column is resized, some tool tip may appear or dissapear.
In my cell factory, I thought there will be a property that I…
Evans Belloeil
- 2,413
- 7
- 43
- 76
3
votes
1 answer
Data truncated at the 256th character - PHP with HFSQL database, using PDO ODBC pilot
I am creating a WebSite with PHP and HyperFileSQL, based on PDO & ODBC for the connection.
I am using the 7.1.9 release of PHP and working under WampServer.
But I have an issue when retrieving text data with more than 255 characters : the data is…
Mickael
- 51
- 4
3
votes
1 answer
Generate data from truncated normal distribution with exact mean and sd in R
I struggle with the following task: I need to generate data from a truncated normal distribution. The sample mean and standard deviation should match exactly those specified in the population. This is what I have so far:
mean <- 100
sd <-…
Lion Behrens
- 199
- 1
- 11
3
votes
3 answers
How do you isolate the digits following a decimal in R?
For example: I have the number 123.456 and want to return 456.
The function trunc() basically isolates (truncates) the numbers before the decimal.
Is there a function to isolate just the digits after the decimal?
Two follow-up questions:
Is there a…
theforestecologist
- 4,667
- 5
- 54
- 91
3
votes
4 answers
How could I get "String or binary data would be truncated" when the value being updated is not too long?
On calling a Stored Proc to retrieve values, in some cases (not all - it all works fine with some data), I get a "String or binary data would be truncated" err msg .
According to this, that happens when you try to insert data that is too long, or…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
3
votes
1 answer
Project Euler #6 Two codes, different answers ONLY for big inputs. Why?
Here are two codes for solving problem 6 in project euler: Why do they give similar answers until I make the number larger? (100,000)
The sum of the squares of the first ten natural numbers is,
12 + 22 + ... + 102 = 385
The square of the sum of…
COOLBEANS
- 729
- 3
- 13
- 31