Hi Arni, On Oct 24, 2012, at 7:51 PM, Arni Sumarlidason wrote:
> Good Day, Thank you for reading, > > I'm working with nutch using the org.hsqldb.jdbc.JDBCDriver connector. I'm > coming across urls with unicode characters, which is causing the jdbc > connector to throw exceptions when inserting into non-utf formatted columns. > With latin1 encoding the id column can have a length of 767 characters. > Switching the encoding to utf8mb4 resolves the issue, but at great cost, now > the max length is 190 characters, or ~767 bytes per primary key/unique key > constraints on the MySQL database. Is there any reason you can't use utf8 columns with MySQL? Cheers, Chris ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: [email protected] WWW: http://sunset.usc.edu/~mattmann/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
