cancel
Showing results for 
Search instead for 
Did you mean: 

Character limitation for a column by MII when a query is fired

Former Member
0 Kudos

Hi All,

Anyone knows what is the character limitation for a column returned by MII when a query is fired..

Suppose i have a table in which a column storing 6000 characters, whan i fire a query in MII to fetch data of that column , how many characters will MII return.

I know the lower version of MII 12.0 there was limitation upto 4000 characters for a column.

Is there any upgradation done for the limitation, if so now how characters will MII return (12.0 and higher versions)

Regards,

Sireesha

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

What is the datatype and name of the database? The 4000 character limitation applies to specific datatypes (like nchar, char, varchar, nvarchar for SQL Server for example). XML, Blob, Clob, etc. have different limitations.

Is there something specific you are trying to do?

There are quite a number of postings on this topic, but you need to go back a year or two (or three) to see the good ones.

Regards,

Mike