> Hum.. I thought Michael Robinson is the one who is against the idea of
> rejecting "illegal" character sequences before they are put in the DB.
> I like the idea but I haven't time to do that (However I'm not sure I
> would like to do it for EUC-CN, since he dislikes the codes I write).
>
> Bruce, I would like to see followings in the TODO. I also would like
> to hear from Thomas and Peter or whoever being interested in
> implementing NATIONAL CHARACTER stuffs if they are reasonable.
>
> o Don't accept character sequences those are not valid as their charset
> (signaling ERROR seems appropriate IMHO)
>
> o Make PostgreSQL more multibyte aware (for example, TRIM function and
> NAME data type)
>
> o Regard n of CHAR(n)/VARCHAR(n) as the number of letters, rather than
> the number of bytes
Added to TODO:
* Reject character sequences those are not valid in their charset * Make functions more multi-byte aware, i.e.
trim()
* Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026