Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2 - Mailing list pgsql-hackers

From Jean-Michel POURE
Subject Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2
Date
Msg-id 200202220741.g1M7fCFP009096@www1.translationforge
Whole thread Raw
In response to Re: UTF-8 data migration problem in Postgresql 7.2  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2
Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2
List pgsql-hackers
Le Jeudi 21 Février 2002 05:04, Tatsuo Ishii a écrit :
> o Were server/clien encodings UTF-8 for PostgreSQL?
Yes, I am absolutely sure. Everything from Web page, Apache to PostgreSQL.

> o What are versions of these softwares? Especially of PHP? Is it a
> PHP4? if so, what version? What is the "Php with UTF-8 extensions"?
> I've never heard of it.

PHP 4.06. PHP needs to be compiled with "--enable-mbstring" to allow the
parsing of UTF-8 files and strings. Internal settings set to UTF-8.

I guess the error might come from PostgreSQL string parsing functions:
1) new.target_content:= translate(new.target_content, chr(146), chr (39)) ;
2) substring(text, int4). Is substring multibyte safe?

Cheers,
Jean-Michel

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Solaris ISM Testing
Next
From: Amit Kumar Khare
Date:
Subject: how to stop running postgres process