Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
netspider
Starting Member
5 Posts |
 Posted - 2008-03-23 : 14:39:36
|
| I'm having a bit of a problem with this data type. It is supposed to be able to store about 2,147,483,647 characters, but when I enter more than about 1,834 characters no more charaters can be stored.Has anyone experienced this and knows how to allow up to the 2,147,483,647 characters. Is it anything to do with another SQL Server setting or variable that needs to be changedThank you in advance for helping on this.RegardsSteve FouracreSteve Fouracre |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 15:43:03
|
| How do you enter data? Did you get any message? |
 |
|
|
netspider
Starting Member
5 Posts |
Posted - 2008-03-26 : 15:33:01
|
| The data is entered by php code, there was no error message, the data is simply truncated and so only part of the data is saved to the database.Thank you for your helpSteve Fouracre |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-03-26 : 15:37:48
|
| Are you sure it's not in the database and it's the retrieval that's the problem?try a datalength on the column.Use the profiler to trace the stament used to update the data to see what php is sending to the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
myaries123
Starting Member
2 Posts |
Posted - 2008-03-27 : 23:24:56
|
| Write the sql statement at the PHP page and copy the sql statement to the Query Analyzer. You will see what is actually passes to the backend database. Most of the time, the problem is not come from the tables, but the frontend.Aries CKY - MY |
|
|
|
|
|
|
Text data type