Em Sábado 10 Junho 2006 05:31, Adam Witney escreveu:
> yep it is there, when i display the data from the application (PHP) it
> shows the character on the web page. Also this causes errors when i dump
> from 7.4 and try to load into 8.1 (i've read that the UNICODE checking
> became more stringent i
Martijn van Oosterhout wrote:
> On Fri, Jun 09, 2006 at 04:32:35PM +0100, Adam Witney wrote:
>>> The database will do it for you. Note that the client encoding affects
>>> input *and* output. So if you set it to latin1, the database will
>>> convert all strings to latin1 before sending them to yo
On Fri, Jun 09, 2006 at 04:32:35PM +0100, Adam Witney wrote:
> > The database will do it for you. Note that the client encoding affects
> > input *and* output. So if you set it to latin1, the database will
> > convert all strings to latin1 before sending them to you...
>
> ok, so my current databa
> For migration, you should pg_dump- it's not clear from your email whether
> you are doing that. If you typed up some sql in Windows which you want to
> load into postgres, you might try:
> set client_encoding to 'LATIN1';
> at the top of your script.
yes this was how i spotted the problem. If
>> I have to replace fields with this in it with a valid string that will
>> load into 8.1, do you know who i would do the conversion?
>
> The database will do it for you. Note that the client encoding affects
> input *and* output. So if you set it to latin1, the database will
> convert all stri
On Fri, June 9, 2006 11:17 am, Adam Witney wrote:
>
>
> Martijn van Oosterhout wrote:
>
>> On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
>>
>>> Hi,
>>>
>>>
>>> Im trying to upgrade from 7.4 -> 8.1 but it is failing with Unicode
>>> errors. The offending character is the greek charac
On Fri, Jun 09, 2006 at 04:17:50PM +0100, Adam Witney wrote:
> > It's a valid unicode character, it's just you havn't encoded it in
> > unicode. It's probably in Latin-1. In that case, you need to specify it
> > in the client encoding...
>
> Hi Martijn,
>
> thanks for your quick response.
>
> Ok
Adam Witney wrote:
Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
Hi,
Im trying to upgrade from 7.4 -> 8.1 but it is failing with Unicode
errors. The offending character is the greek character mu (often used
for micro). Here is an offending stri
Martijn van Oosterhout wrote:
> On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
>> Hi,
>>
>> Im trying to upgrade from 7.4 -> 8.1 but it is failing with Unicode
>> errors. The offending character is the greek character mu (often used
>> for micro). Here is an offending string "[EMAIL
On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
>
> Hi,
>
> Im trying to upgrade from 7.4 -> 8.1 but it is failing with Unicode
> errors. The offending character is the greek character mu (often used
> for micro). Here is an offending string "[EMAIL PROTECTED]" (in case it
> doesn't
10 matches
Mail list logo
