mardi 24 février 2015

Convert Java String to MySQL Datatype



So I am trying to convert some string values from Java into MySQL, I have tried using the datatype 'varchar' but the values I am passing over are web pages' source (so the HTML of a webpage) and are too large for that datatype, if I have a string of a webpages' HTML and trying to add it to MySQL as a value, what datatype can I use? I tried changing the datatype in MySQL to my column as a 'TEXT' and other datatypes, but they get this error, which I think is a problem because I am trying to execute my insert with a string value which cannot be inserted to those datatypes, any help would be appreciated:



Query error:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException



Aucun commentaire:

Enregistrer un commentaire