MySQL varchar limitation

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 375,174 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,233 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 17471 | Replies: 2

•

Join Date: May 2005

Posts: 5

Reputation: Chagh is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Chagh

Offline

Newbie Poster

MySQL varchar limitation

Jun 1st, 2005

hi all,
i want to migrate from SQLSerevr 2000 to MySQL 5.0.4. i've got a column type varchar(8000) in my source db. the reason of selecting varchar(8000) instead of text type is: we can't compare two text fields in SQLserver and i need to compare them some times.
i don't want to change my application and cause of mysqls limitation in up to 256 char in a varchar,So i can't use varchar.
what should I do in your opinion?

Thanks in advance
Chagh

•

Join Date: May 2005

Posts: 16

Reputation: vark is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

vark

Offline

Newbie Poster

Re: MySQL varchar limitation

Jul 7th, 2005

maybe a blob.

•

Join Date: Jul 2005

Posts: 1

Reputation: filip_scm is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

filip_scm

Offline

Newbie Poster

Re: MySQL varchar limitation

Jul 15th, 2005

A variable-length string. M represents the maximum column length. The range of M is 1 to 255 before MySQL 4.0.2, 0 to 255 as of MySQL 4.0.2, and 0 to 65,535 as of MySQL 5.0.3. (The maximum actual length of a VARCHAR in MySQL 5.0 is determined by the maximum row size and the character set you use. The maximum effective length is 65,532 bytes.)