I have a data base, and i can upload things to it - but i have one of my text fields set to 2000 caracters - but i only seem to be able to put up to 1000 in it.
Its set as 'TEXT' '2000 lengh' 'latin1_swedish_ci' and 'not null'
why cant i write more text than 1000 caracters?

You should be able to find your answer in the manual of your db.
Or at least tell us what db this is !
Oracle, fireBird, mysql , mssql, postgresql, db2, informix, sqlite ???

And it may not be a DB problem.
Maybe something in the code of the site you use to populate the db is stripping the 1000 first characters.

Its a mysql db
in my script i have it set as 2000 caracters

You are using PHP with the db ?
If so, PHP cannot limit a variable size, so it's not in your script.

Mysql may have a limit, but if you try to dump the query sent to your db, does it contains 2000 character or does it contains only 1000.
If the second case apply, there is something into your script code that truncate the datas, not mysql.
If your query datas are 2000+ characters long, then the problem lies in the DB scope.

But I think that it's more than probable that the problem is on the script side.
A bug like that one would have been spotted long before the release of any version of the DB. It's way too critical.

Can you post your table schema and relevant code you are calling it from?

Originally Posted by coldturkey

Its a mysql db
in my script i have it set as 2000 caracters

You must also have it set to international or unicode. If you were using SQL Server, that would be nText instead of text. In Oracle, it's text2 instead of text. I don't know in MySql how you do that...?