Hsqldb表编码 [英] Hsqldb table encoding

问题描述

如何设置特定表的字符编码？例如：

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)
)

默认情况下，但我宁愿使用UTF-8作为这个表格。

By default it's encoded as ASCII but I'd rather use UTF-8 for this one table.

推荐答案

您确定它默认编码为ASCII？我的读法是，它是默认的UTF-8，虽然我可以更正这里。

Are you sure that it's encoded as ASCII by default? My reading of it was that it's UTF-8 by default, though I'm open to correction here.

如果是一个TEXT表，你可以指定编码表

If it's a TEXT table you'll can specify the encoding for the table

SET TABLE mytable SOURCE "myfile;encoding=UTF-8"

这篇关于Hsqldb表编码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！