Advertisement

1 - 10 of 11 containing alltags:("Truncating Data") (0.001 seconds)
Hi All I am having table with column description of text datatype.When i save the character data using insert statement of length 20000 it gets truncated to only 5000 charaters in the table. ...
Zones: MS SQL ServerDate Answered: 10/24/2003 Grade: A Views: 0
I have a search form based on a date range, then on zip code. Here is the relevant query: <cfquery name="dosearch" datasource="blah"> SELECT * FROM visitorinfo WHERE visitdate BETWEEN '#form....
Zones: ColdFusion Application ServerDate Answered: 10/26/2005 Grade: A Views: 0
I am currently uploading large amounts of data into a mysql database using php. I upgraded to MySQL 5.0.16 and php 5.1.1 and now I'm getting an error that says: "Data truncated for column x at row ...
Zones: MySQL ServerDate Answered: 02/01/2006 Grade: A Views: 167
Hi all, I've got a problem reading data from an Microsoft Acess-table (office 97) with a memo field. I derived a class from CRecordset with a wizard and I pointed to the table, so the wizard could...
Zones: Windows MFCDate Answered: 09/14/1998 Grade: B Views: 0
HMMM...weird thing happened....now after converting that field to a smalldatetime...when I open the search form I get this error: [Microsoft][ODBC SQL Server Driver]String data, right truncation...
Zones: MS SQL ServerDate Answered: 06/20/2004 Grade: B Views: 0
Hello I made an export and import to an Oracle 8.1.6 DB in order to change the codepage from the Greek codepage to UTF8. The process is described to my previous question: 'Convert Oracle codepag...
Zones: OracleDate Answered: 03/15/2005 Grade: A Views: 0
I have two servers one is running firebird (on linux) and other have Oracle (on windows), firebird ODBC installed on windows(oracle) system. Problem when we fetch data from firebird through odbc...
Zones: Interbase / FirebirdDate Answered: 05/20/2007 Grade: A Views: 4
Hi, I am using Microsoft Access Queries to retrieve some Oracle data. The Queries that i did involved 7 Oracle tables and i had done the necessary tables joining. After that, i have selected the...
Zones: MS AccessDate Answered: 06/19/2003 Grade: B Views: 0
I have a strange problem with mySQL. I am running version 5.0.27 on my development server which is the same version as my webhost. For this reason I dont want to upgrade above this version number a...
Zones: MySQL ServerDate Answered: 05/17/2007 Grade: A Views: 6
Is it possible either in Excel or in Access to take data that is over 240 characters, cut it off and move the remaining character to another field and then again if it is over 240 characters to cut...
Zones: MS Access, SQL Syntax, Acce...Date Answered: 06/17/2008 Grade: A Views: 0