The Artima Developer Community
Sponsored Link

Java Answers Forum
Simple question in MySQL

2 replies on 1 page. Most recent reply: Nov 30, 2003 8:11 AM by s

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 2 replies on 1 page
jilshi

Posts: 9
Nickname: kj2003
Registered: Nov, 2003

Simple question in MySQL Posted: Nov 28, 2003 5:43 PM
Reply to this message Reply
Advertisement
MySQL database system can store (maximum) how many character in one datafield ?

i asked this question because, i want to write a program to store record into MySQL database and i want to know the maximum number of character that i can set ?


Singh M.

Posts: 154
Nickname: ms
Registered: Mar, 2002

Re: Simple question in MySQL Posted: Nov 28, 2003 7:30 PM
Reply to this message Reply
> MySQL database system can store (maximum) how many
> character in one datafield ?
>
> i asked this question because, i want to write a program
> to store record into MySQL database and i want to know the
> maximum number of character that i can set ?

It depends on type of the datafield you use. What specifically do you have in your mind?

s

Posts: 23
Nickname: codemonkey
Registered: Nov, 2003

Re: Simple question in MySQL Posted: Nov 30, 2003 8:11 AM
Reply to this message Reply
LONGBLOB/LONGTEXT types are the biggest i believe...
This is the description from the 3.23 documentation:

A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. See section 7.7.1 Silent Column Specification Changes. Note that because the server/client protocol and MyISAM tables has currently a limit of 16M per communication packet / table row, you can't yet use this the whole range of this type.

I seem to remember a way around the packet size limitation though...i think we had to get around it in our projects.

Flat View: This topic has 2 replies on 1 page
Topic: Help please Previous Topic   Next Topic Topic: ScrollBar problem..

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use