Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

SQL Custom Field limit..

Oct 19, 2003, 1:31 PM
katabd
Veteran (1187 posts)
Oct 19, 2003, 1:31 PM
Post #1 of 13
Views: 4247
Shortcut
Quote Reply
SQL Custom Field limit..
Hi

I added a custom field to the Links table.. Called Article..

In that field we store articles and books details..

I am facing a limit on this field so we can not add more that specific number of charectors..

Any reason for this and how can we fix it?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Oct 20, 2003, 1:14 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Oct 20, 2003, 1:14 AM
Post #2 of 13
Views: 4180
Shortcut
Quote Reply
Re: [katabd] SQL Custom Field limit.. In reply to
TEXT or CHAR field? TEXT is limited to 255 charachters, but CHAR can handle a *lot* more.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Oct 20, 2003, 2:29 AM
yogi
Veteran / Moderator (2199 posts)
Oct 20, 2003, 2:29 AM
Post #3 of 13
Views: 4166
Shortcut
Quote Reply
Re: [Andy] SQL Custom Field limit.. In reply to
Just the other way round...

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Oct 20, 2003, 3:36 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Oct 20, 2003, 3:36 AM
Post #4 of 13
Views: 4169
Shortcut
Quote Reply
Re: [yogi] SQL Custom Field limit.. In reply to
Too early in the morning Crazy

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Oct 20, 2003, 4:10 AM
katabd
Veteran (1187 posts)
Oct 20, 2003, 4:10 AM
Post #5 of 13
Views: 4163
Shortcut
Quote Reply
Re: [Andy] SQL Custom Field limit.. In reply to
It is TEXT
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Oct 20, 2003, 4:39 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Oct 20, 2003, 4:39 AM
Post #6 of 13
Views: 4162
Shortcut
Quote Reply
Re: [katabd] SQL Custom Field limit.. In reply to
Exactly what error are you getting?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Oct 20, 2003, 3:39 PM
katabd
Veteran (1187 posts)
Oct 20, 2003, 3:39 PM
Post #7 of 13
Views: 4131
Shortcut
Quote Reply
Re: [Andy] SQL Custom Field limit.. In reply to
Hi

No error..

You paste an article with 1000 words for example and only 500 or so will be saved..
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Oct 21, 2003, 12:05 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Oct 21, 2003, 12:05 AM
Post #8 of 13
Views: 4144
Shortcut
Quote Reply
Re: [katabd] SQL Custom Field limit.. In reply to
Sounds more like a browser limitation Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Oct 21, 2003, 7:46 AM
katabd
Veteran (1187 posts)
Oct 21, 2003, 7:46 AM
Post #9 of 13
Views: 4129
Shortcut
Quote Reply
Re: [Andy] SQL Custom Field limit.. In reply to
THanbks Andy

But I do not think it is the browser as I try inseryting the text through the SQL drive directly and had the same trouble..

Any ideas on this is great..
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Oct 21, 2003, 3:03 PM
afinlr
Veteran (1921 posts)
Oct 21, 2003, 3:03 PM
Post #10 of 13
Views: 4101
Shortcut
Quote Reply
Re: [katabd] SQL Custom Field limit.. In reply to
I think that the limit in a text field is something like 65,000 characters - so I think it is unlikely to be a sql limit that it causing the problem. Do you mean that you are pasting the text straight into the field in mysqlman and it is cutting it off when you save the record?
Oct 21, 2003, 3:05 PM
katabd
Veteran (1187 posts)
Oct 21, 2003, 3:05 PM
Post #11 of 13
Views: 4091
Shortcut
Quote Reply
Re: [afinlr] SQL Custom Field limit.. In reply to
Yes it is..

I have lots of space.. the field is set to text....!! No idea what it is..!
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Oct 23, 2003, 6:33 PM
Alex
Administrator (9387 posts)
Oct 23, 2003, 6:33 PM
Post #12 of 13
Views: 4088
Shortcut
Quote Reply
Re: [katabd] SQL Custom Field limit.. In reply to
What database are you using? MySQL's limit on a text field is 65 thousand characters. Try it from the mysql command prompt and see if it gives you an error. Also, try a `DESCRIBE table` to make sure it is actually a text field.

Cheers,

Alex
--
Gossamer Threads Inc.
Oct 23, 2003, 8:00 PM
katabd
Veteran (1187 posts)
Oct 23, 2003, 8:00 PM
Post #13 of 13
Views: 4070
Shortcut
Quote Reply
Re: [Alex] SQL Custom Field limit.. In reply to
Thnak Alex

It is a Text field.. and I did try from the Mysql command and it did not work..

I gave up on this and I am using straight template for each book.. Pirate
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory