Re: client libpq multibyte support
От | SAKAIDA Masaaki |
---|---|
Тема | Re: client libpq multibyte support |
Дата | |
Msg-id | 3912F18228A.D70ESAKAIDA@smtp.psn.ne.jp обсуждение исходный текст |
Ответ на | Re: client libpq multibyte support (Tatsuo Ishii <t-ishii@sra.co.jp>) |
Список | pgsql-hackers |
Tatsuo Ishii <t-ishii@sra.co.jp> wrote: > > > admin=# select * from SJIS_KANJI ; > > > \: extra argument ';' ignored > > > \: extra argument ';' ignored > > > Invalid command \. Try \? for help. > > (snip) > > That's because none-MB client does not understand how "Shift JIS > kanji" consists of letters with different width bytes. The similar > problem would happen with the Big5 character set (traditional > Chinese), also. Unlike other character sets, these should be treated > carefully since they include the same bit patterns as ASCII and that > makes none-MB clients confused. Thank you for your reply. (Probably, the direct cause of this error is PQmblen(). non-MULTIBYTE-PQmblen() always return "1". ) > Anyway, I could hardly imagine that such configurations > would actually exist in the real world. Masaaki, could you tell me > what are the advantages or reasons of the configuration? # My poor English won't be able to explain the real world ;-). If a client libpq always be made by "configure --enable- multibute", the advantages are 1. In the case of SQL_ASCII, a client application speed is almost equal to non-MULTIBYTE. And the MULTIBYTE code is not so larger. 2. When required, by using "set client_encoding=xxx", it is possible to use the MULTIBYTE at anytime. -- Regard, SAKAIDA Masaaki -- Osaka, Japan
В списке pgsql-hackers по дате отправления: