Reply
Data base - value lengh
Old 12-06-2007, 08:11 AM Data base - value lengh
coldturkey's Avatar
Extreme Talker

Posts: 195
Name: Rachel
Location: Spain
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?
__________________
coldturkey is offline
Reply With Quote
View Public Profile Visit coldturkey's homepage!
 
When You Register, These Ads Go Away!
Old 12-06-2007, 08:20 AM Re: Data base - value lengh
tripy's Avatar
Fetchez la vache!

Posts: 2,171
Name: Thierry
Location: In the void
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.
__________________
Listen to the ducky: "This is awesome!!!"

tripy is online now
Reply With Quote
View Public Profile
 
Old 12-06-2007, 10:53 AM Re: Data base - value lengh
coldturkey's Avatar
Extreme Talker

Posts: 195
Name: Rachel
Location: Spain
Its a mysql db
in my script i have it set as 2000 caracters
__________________
coldturkey is offline
Reply With Quote
View Public Profile Visit coldturkey's homepage!
 
Old 12-06-2007, 10:59 AM Re: Data base - value lengh
tripy's Avatar
Fetchez la vache!

Posts: 2,171
Name: Thierry
Location: In the void
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.
__________________
Listen to the ducky: "This is awesome!!!"

tripy is online now
Reply With Quote
View Public Profile
 
Old 12-06-2007, 10:50 PM Re: Data base - value lengh
joder's Avatar
Flipotron

Posts: 6,443
Name: James
Location: In the ocean.
Can you post your table schema and relevant code you are calling it from?
joder is offline
Reply With Quote
View Public Profile
 
Old 12-06-2007, 11:16 PM Re: Data base - value lengh
ForrestCroce's Avatar
Half Man, Half Amazing

Posts: 3,024
Name: Forrest Croce
Location: Seattle, WA
Quote:
Originally Posted by coldturkey View Post
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...?
ForrestCroce is offline
Reply With Quote
View Public Profile Visit ForrestCroce's homepage!
 
Reply     « Reply to Data base - value lengh
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Webmaster Resources Marketplace:
Software Development Company | Webhosting.UK.com | Text Link Brokers 


   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.13097 seconds with 12 queries