I am having a problem with Java Studio Creator because the latest version of the JDBC driver returns a field length of -1 for text fields.
My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want to use the data binding part of the JSC tool I will need to convert my text fields to some standard SQL data type. I understand that varchar just stores the actual length of the field. Would anyone recommend for or against creating a field of varchar(Integer.MAX_VALUE)? If against, how is text implemented and how can I represent it in a SQL standard format?
Thanks.
My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want to use the data binding part of the JSC tool I will need to convert my text fields to some standard SQL data type. I understand that varchar just stores the actual length of the field. Would anyone recommend for or against creating a field of varchar(Integer.MAX_VALUE)? If against, how is text implemented and how can I represent it in a SQL standard format?
Thanks.