>> Perhaps the worst case for MB would be regex ops. If you do a lot of
>> regex queries, performance degration might not be neglectable.
>
>It should be. What would be nice is to have a column-specific
>MB support. But I doubt if it's possible.
That shouldn't be too difficult, if we have an encoding infomation
with each text column or literal. Maybe now is the time to introuce
NCHAR?
BTW, it is interesting that people does not hesitate to enable
with-locale option even if they only use ASCII. I guess the
performance degration by enabling locale is not too small.
--
Tatsuo Ishii