Hsqldb表编码 [英] Hsqldb table encoding
本文介绍了Hsqldb表编码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何设置特定表格的字符编码?例如:
CREATE TABLE COMMENTS(
ID INTEGER由DEFAULT ASIDENTITY生成(START WITH 0,INCREMENT BY 1)NOT NULL ,
TXT LONGVARCHAR,
PRIMARY KEY(ID)
)
默认情况下,它被编码为ASCII但是我宁愿在这个表中使用UTF-8。
解决方案
HSQLDB肯定会将所有数据存储在Unicode中(除了例外的TEXT表,您必须指定UTF-8)。因此,您不需要为普通表指定字符编码。
How do I set the character encoding for a specific table? E.g:
CREATE TABLE COMMENTS ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL, TXT LONGVARCHAR, PRIMARY KEY (ID) )
By default it's encoded as ASCII but I'd rather use UTF-8 for this one table.
解决方案
HSQLDB certainly stores all data in Unicode (with the exception of TEXT tables where you have to specify UTF-8). Therefore you don't need to specify a character encoding for normal tables.
这篇关于Hsqldb表编码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文