Java Answers Forum - Simple question in MySQL

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

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

Back to Topic List

Reply to this Topic

Search Forum

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

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

> 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

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

Previous Topic

Next Topic


	Web Artima.com