Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



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

Posts: 211
Name: Rachel
Location: Spain
Trades: 3
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?
__________________

Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE

coldturkey is offline
Reply With Quote
View Public Profile Visit coldturkey's homepage!
 
 
Register now for full access!
Old 12-06-2007, 08:20 AM Re: Data base - value lengh
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
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.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 12-06-2007, 10:53 AM Re: Data base - value lengh
coldturkey's Avatar
Extreme Talker

Posts: 211
Name: Rachel
Location: Spain
Trades: 3
Its a mysql db
in my script i have it set as 2000 caracters
__________________

Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE

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
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
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.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 12-06-2007, 10:50 PM Re: Data base - value lengh
joder's Avatar
Flipotron

Posts: 6,442
Name: James
Location: In the ocean.
Trades: 0
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,023
Name: Forrest Croce
Location: Seattle, WA
Trades: 0
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...?
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
ForrestCroce is offline
Reply With Quote
View Public Profile Visit ForrestCroce's homepage!
 
Reply     « Reply to Data base - value lengh
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

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





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



Page generated in 0.25002 seconds with 12 queries