com.aoindustries.aoserv.client.postgresql.Encoding Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of aoserv-client Show documentation
Show all versions of aoserv-client Show documentation
Java client for the AOServ Platform.
/*
* aoserv-client - Java client for the AOServ Platform.
* Copyright (C) 2001-2009, 2016, 2017, 2018, 2019, 2020 AO Industries, Inc.
* [email protected]
* 7262 Bull Pen Cir
* Mobile, AL 36695
*
* This file is part of aoserv-client.
*
* aoserv-client is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* aoserv-client is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with aoserv-client. If not, see .
*/
package com.aoindustries.aoserv.client.postgresql;
import com.aoindustries.aoserv.client.AOServConnector;
import com.aoindustries.aoserv.client.GlobalObjectIntegerKey;
import com.aoindustries.aoserv.client.schema.AoservProtocol;
import com.aoindustries.aoserv.client.schema.Table;
import com.aoindustries.io.stream.StreamableInput;
import com.aoindustries.io.stream.StreamableOutput;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* Beginning with PostgreSQL 7.1, multiple character encoding formats are
* supported, the PostgresEncoding
s represent the possible
* formats.
*
* @see Database
*
* @author AO Industries, Inc.
*/
final public class Encoding extends GlobalObjectIntegerKey {
static final int
COLUMN_PKEY=0,
COLUMN_POSTGRES_VERSION=2
;
static final String COLUMN_ENCODING_name = "encoding";
static final String COLUMN_POSTGRES_VERSION_name = "postgres_version";
static final String COLUMN_PKEY_name = "pkey";
/**
* The supported encodings.
*/
public static final String
ALT="ALT", // 7.1 7.2 7.3 8.0
BIG5="BIG5", // 7.1 7.2 7.3
EUC_CN="EUC_CN", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
EUC_JIS_2004="EUC_JIS_2004", // 9.4 9.5 9.6 10 11 12
EUC_JP="EUC_JP", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
EUC_KR="EUC_KR", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
EUC_TW="EUC_TW", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
GB18030="GB18030", // 7.3
GBK="GBK", // 7.3
ISO_8859_5="ISO_8859_5", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
ISO_8859_6="ISO_8859_6", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
ISO_8859_7="ISO_8859_7", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
ISO_8859_8="ISO_8859_8", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
JOHAB="JOHAB", // 7.3 8.0
KOI8="KOI8", // 7.1 7.2 7.3 8.0
KOI8R="KOI8R", // 9.4 9.5 9.6 10 11 12
KOI8U="KOI8U", // 9.4 9.5 9.6 10 11 12
LATIN1="LATIN1", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN2="LATIN2", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN3="LATIN3", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN4="LATIN4", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN5="LATIN5", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN6="LATIN6", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN7="LATIN7", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN8="LATIN8", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN9="LATIN9", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
LATIN10="LATIN10", // 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
MULE_INTERNAL="MULE_INTERNAL", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
SJIS="SJIS", // 7.1 7.2 7.3
SQL_ASCII="SQL_ASCII", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
UTF8="UTF8", // 9.4 9.5 9.6 10 11 12
TCVN="TCVN", // 7.3 8.0
UHC="UHC", // 7.3
UNICODE="UNICODE", // 7.1 7.2 7.3 8.0
WIN="WIN", // 7.1 7.2 7.3 8.0
WIN866="WIN866", // 9.4 9.5 9.6 10 11 12
WIN874="WIN874", // 7.3 8.0 9.4 9.5 9.6 10 11 12
WIN1250="WIN1250", // 7.1 7.2 7.3 8.0 9.4 9.5 9.6 10 11 12
WIN1251="WIN1251", // 9.4 9.5 9.6 10 11 12
WIN1252="WIN1252", // 9.4 9.5 9.6 10 11 12
WIN1253="WIN1253", // 9.4 9.5 9.6 10 11 12
WIN1254="WIN1254", // 9.4 9.5 9.6 10 11 12
WIN1255="WIN1255", // 9.4 9.5 9.6 10 11 12
WIN1256="WIN1256", // 7.3 8.0 9.4 9.5 9.6 10 11 12
WIN1257="WIN1257", // 9.4 9.5 9.6 10 11 12
WIN1258="WIN1258" // 9.4 9.5 9.6 10 11 12
;
/**
* Gets the default PostgreSQL encoding for the given database version.
* Version <= 8.3: SQL_ASCII.
* Version >= 9.4: UTF8
*/
public static String getDefaultEncoding(String version) {
if(
version.startsWith("7.")
|| version.startsWith("8.")
) {
return SQL_ASCII;
} else {
return UTF8;
}
}
String encoding;
int postgres_version;
@Override
protected Object getColumnImpl(int i) {
switch(i) {
case COLUMN_PKEY: return pkey;
case 1: return encoding;
case COLUMN_POSTGRES_VERSION: return postgres_version;
default: throw new IllegalArgumentException("Invalid index: " + i);
}
}
public String getEncoding() {
return encoding;
}
public Version getPostgresVersion(AOServConnector connector) throws SQLException, IOException {
Version pv=connector.getPostgresql().getVersion().get(postgres_version);
if(pv==null) throw new SQLException("Unable to find PostgresVersion: "+postgres_version);
return pv;
}
@Override
public Table.TableID getTableID() {
return Table.TableID.POSTGRES_ENCODINGS;
}
@Override
public void init(ResultSet result) throws SQLException {
pkey=result.getInt(1);
encoding=result.getString(2);
postgres_version=result.getInt(3);
}
@Override
public void read(StreamableInput in, AoservProtocol.Version protocolVersion) throws IOException {
pkey=in.readCompressedInt();
encoding=in.readUTF().intern();
postgres_version=in.readCompressedInt();
}
@Override
public void write(StreamableOutput out, AoservProtocol.Version protocolVersion) throws IOException {
out.writeCompressedInt(pkey);
out.writeUTF(encoding);
out.writeCompressedInt(postgres_version);
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy