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.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20287350.html
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....
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21608463...
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 ...
http://www.experts-exchange.com/Databases/Mysql/Q_21715860.html
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...
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_10078788.htm...
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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20795932.html
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...
http://www.experts-exchange.com/Database/Oracle/Q_21336492.html
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...
http://www.experts-exchange.com/Database/Interbase_Firebird/Q_22495943.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20629668.html
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...
http://www.experts-exchange.com/Database/MySQL/Q_22577762.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23476801.html