pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: phd2@earthling.net, "'Oleg Bartunov'" <oleg@sai.msu.su>
Cc: 'hackers@postgresql.org' <hackers@postgreSQL.org>
Cc: Tatsuo Ishii <t-ishii@sra.co.jp>
Subject: Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem
Date: Mon, 14 Jun 1999 23:07:08 +0900
Message-ID: <199906141407.XAA00874@ext16.sra.co.jp> (raw)
In-Reply-To: <37612A0D.BAF8B997@alumni.caltech.edu>

> OK, SQL92 defines two kinds of native character sets: those we already
> have (char, varchar) and those which can be locale customized (nchar,
> national character varying, and others). char and varchar always
> default to the "SQL" behavior (which I think corresponds to ascii
> (called "SQL_TEXT") but I didn't bother looking for the details).

This seems to be a little bit different from the standard. First,
SQL_TEXT is not equal to ascii. It's a subset of ascii. Second, the
default charset for char and varchar might be implemenation dependent,
not neccesarily limited to SQL_TEXT. The only requirement is the
charset must contain the repertoire SQL_TEXT has. I think any charsets
including ascii I've ever seen satisfies the requirement. Third, the
standards says nothing about locale.
---
Tatsuo Ishii



view thread (41+ messages)  latest in thread

Message-ID: <199906141407.XAA00874@ext16.sra.co.jp>
Permalink:  ../199906141407.XAA00874@ext16.sra.co.jp/
Also on:    postgresql.org/message-id/199906141407.XAA00874@ext16.sra.co.jp

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: t-ishii@sra.co.jp, lockhart@alumni.caltech.edu, oleg@sai.msu.su, hackers@postgreSQL.org
  Subject: Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem
  In-Reply-To: <199906141407.XAA00874@ext16.sra.co.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox