0

I need to store double byte chars (Japanese Kanji) in an in-memory DB within a Java EE web app.

I'm considering using HSQL.

Will it support double byte chars?

Arjan Tijms
  • 37,782
  • 12
  • 108
  • 140
Thomas Buckley
  • 5,836
  • 19
  • 62
  • 110
  • What encoding will you be using? HSQLDB is in UTF-8 by default, unless you specify otherwise. Then each Kanji char would take up 3 bytes, is that problematic? – Mr Lister Jul 17 '13 at 12:59
  • I don't believe so. So I would just have to ensure that I setup my columns size correctly to consider Kanji? i.e. CHAR(21) will allow 7 kanji symbols if I leave as UTF-8. The DB will need to store the address reference data in both English and Kanji. – Thomas Buckley Jul 17 '13 at 13:18
  • HSQLDB always uses Unicode UTF-16, which is double byte per character. – fredt Jul 17 '13 at 14:49

0 Answers0