I've written an application that reads user input from a textArea and stores it in a string. This string is sent to a db with JDBC.
The cells in the db is of the type varchar(8000), because of this I have to create substrings if the user input is above 8000 chars.
When I split the string into substrings I get a SQL error when trying to INSERT it to my MSSQL db.
Disallowed implicit conversion from ntext to varchar
Why? Why isn't varchar compatible with substrings and whats the easiest solution?