Re: Mixed UTF8 / Latin1 database

Поиск
Список
Период
Сортировка
От Jean-Michel POURE
Тема Re: Mixed UTF8 / Latin1 database
Дата
Msg-id 200404161626.24868.jm@poure.com
обсуждение исходный текст
Ответ на Mixed UTF8 / Latin1 database  (Claudio Cicali <c.cicali@mclink.it>)
Ответы Re: Mixed UTF8 / Latin1 database  (Markus Bertheau <twanger@bluetwanger.de>)
Список pgsql-general
> I'm wondering if anyone could have a script or something to help me
> with this situation... :(

Knowing that Unicode is composed of plain ASCII characters,
you may perform a conversion test using PHP "recode" function.

You may test each record as follows:

$test = recode ("latin1..u8", $record);

If the $test value differs from the $record one, then it is a Latin1 string.

On the converse, it is Unicode UT-8. There is no garantee. Make a test on a
few values, I am not coding right now and only have access to email.

Cheers,
Jean-Michel


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PLpgSQL-Problem
Следующее
От: Giorgio Valoti
Дата:
Сообщение: Locale support on Mac OS X