Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Maximum length for columns of SQL type varchar

fbergstrand

Hi,

I've been running a couple of processes in Rapidminer in which I run my query to write database in MySQL.

I've been uploading quite a few datasets with no issues but experienced an error message I've never seen before.

"attribute page ref contains values with length> 255 which is the maximum length for columns of SQL type Varchar"

I'm using the write database operator and other files and processes are fine to upload. When I look at mySql table the attributes Page_ref is of datatype varchar(900). I've tried to both tick and untick the set dafault varchar lenght in the write database operator but it does not seem to make a difference.

Any ideas what is causing this error?

Find more posts tagged with

AI Studio

SQL

Accepted answers

Edin_Klapic

Hi,

try using the Operator "Nominal to Text" and convert the relevant attributes to the value type Text. Then you do not run into issues if there will be entries longer than 900 characters in the future.

Best,

Edin

All comments

Thomas_Ott

@BalazsBarany any idea?

BalazsBaranyRM

Hi,

I tested it on a MySQL database (5.5.55) with RM Studio 7.4. Created a table with a VARCHAR(1200) column.

Write Database was able to write long nominal values into the table without problems (even longer than 1200 characters - known misfeature of MySQL). I tested both MyISAM and InnoDB tables.

What is your database version? Since MySQL 5.0.3 it is possible to have VARCHARs with more than 255 characters. However, there's an overall row size limit (65,535).

Regards,

Balázs

fbergstrand

Hi,

My MySQL database is version 6.3.3.

What's confusing is that I'm able to write very similiar processes without any issues.

Edin_Klapic

Hi,

try using the Operator "Nominal to Text" and convert the relevant attributes to the value type Text. Then you do not run into issues if there will be entries longer than 900 characters in the future.

Best,

Edin

fbergstrand

Great, thanks this worked!

@Edin_Klapic wrote:
Hi,

try using the Operator "Nominal to Text" and convert the relevant attributes to the value type Text. Then you do not run into issues if there will be entries longer than 900 characters in the future.

Best,

Edin