You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Thibaut <la...@ifrance.com> on 2006/05/12 12:12:23 UTC

UTF6 Iso-8859-1

Hi

I use james-2.2.0 and MySQL 4.1.12.

I record incoming mail in the DB but "010203040506070809" become "1"

The mail i post is :

Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


And the database is MySQL:* *UTF-8 Unicode

How can i solve this problem ?
**



---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


Re: UTF6 Iso-8859-1

Posted by Thibaut <la...@ifrance.com>.
I found the solution. I made a mistake.
Sorry and thank you for your time.

Thibaut

Stefano Bagnara a écrit :
> I don't understand why the System.out.println return \01\02.. instead
> of 0102, etc. Is the 01 a 0x01 (the byte "01") or 01 (the sequence of
> the char "0" and the char "1") ??
>
> If I send the message you posted it's saved correctly in my utf8 db.
>
> Where did you posted the message from? How do you send it to James?
> Where do you write the System.out.println() ? what arguments do you
> pass to println() ??
>
> James 2.2.0 does not support 8bitmime so that message is not sent to
> James as you wrote it. Probably your client (Thunderbird?) convert it
> to 7bit before sending it.
>
> Stefano
>
> Thibaut wrote:
>> here is the mail i send :
>>
>>> From - Fri May 12 15:01:48 2006
>> X-Mozilla-Status: 0001
>> X-Mozilla-Status2: 00800000
>> Message-ID: <44...@cvdunet.com>
>> Date: Fri, 12 May 2006 15:01:43 +0200
>> From: Thibaut Lassalle <tl...@cvdunet.com>
>> User-Agent: Thunderbird 1.5 (X11/20051201)
>> MIME-Version: 1.0
>> To:  post19@posteone.com
>> Subject: essai
>> Content-Type: text/plain; charset=ISO-8859-1
>> Content-Transfer-Encoding: 8bit
>>
>> 010203040506070809
>> 010203040506070809
>> 010203040506070809
>>
>> ê î ç à
>> ê î ç à
>>
>>
>>
>>
>>
>> I put a System.out.println() to see what is received :
>>
>> \01\02\03\04\05\06\07\08\09^M
>> \01\02\03\04\05\06\07\08\09^M
>> \01\02\03\04\05\06\07\08\09^M
>> ^M
>> ê î ç à^M
>> ê î ç à
>>
>>
>>
>> But here is what i have in my mysql (via phpMyAdmin 2.6.2-rc1) :
>>
>>
>>
>> 1
>>
>>
>>
>>
>> ê î ç à
>> ê î ç à
>>
>>
>>
>>
>>
>>
>> Thank you for your help.
>>
>>
>>
>>
>>
>> Stefano Bagnara a écrit :
>>> You should provide more informations.
>>>
>>> What "010203040506070809" become "1" ??
>>>
>>> Please post the full source of the mail you post (there is no
>>> 010203040506070809 in the 2 headers you posted) and any change you did
>>> to the default configuration.
>>>
>>> Stefano
>>>
>>> Thibaut wrote:
>>>> Hi
>>>>
>>>> I use james-2.2.0 and MySQL 4.1.12.
>>>>
>>>> I record incoming mail in the DB but "010203040506070809" become "1"
>>>>
>>>> The mail i post is :
>>>>
>>>> Content-Type: text/plain; charset=ISO-8859-1
>>>> Content-Transfer-Encoding: 7bit
>>>>
>>>>
>>>> And the database is MySQL:* *UTF-8 Unicode
>>>>
>>>> How can i solve this problem ? 
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


Re: UTF6 Iso-8859-1

Posted by Stefano Bagnara <ap...@bago.org>.
I don't understand why the System.out.println return \01\02.. instead of 
0102, etc. Is the 01 a 0x01 (the byte "01") or 01 (the sequence of the 
char "0" and the char "1") ??

If I send the message you posted it's saved correctly in my utf8 db.

Where did you posted the message from? How do you send it to James?
Where do you write the System.out.println() ? what arguments do you pass 
to println() ??

James 2.2.0 does not support 8bitmime so that message is not sent to 
James as you wrote it. Probably your client (Thunderbird?) convert it to 
7bit before sending it.

Stefano

Thibaut wrote:
> here is the mail i send :
> 
>>>From - Fri May 12 15:01:48 2006
> X-Mozilla-Status: 0001
> X-Mozilla-Status2: 00800000
> Message-ID: <44...@cvdunet.com>
> Date: Fri, 12 May 2006 15:01:43 +0200
> From: Thibaut Lassalle <tl...@cvdunet.com>
> User-Agent: Thunderbird 1.5 (X11/20051201)
> MIME-Version: 1.0
> To:  post19@posteone.com
> Subject: essai
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 8bit
> 
> 010203040506070809
> 010203040506070809
> 010203040506070809
> 
> ê î ç à
> ê î ç à
> 
> 
> 
> 
> 
> I put a System.out.println() to see what is received :
> 
> \01\02\03\04\05\06\07\08\09^M
> \01\02\03\04\05\06\07\08\09^M
> \01\02\03\04\05\06\07\08\09^M
> ^M
> ê î ç à^M
> ê î ç à
> 
> 
> 
> But here is what i have in my mysql (via phpMyAdmin 2.6.2-rc1) :
> 
> 
> 
> 1
> 
> 
> 
> 
> ê î ç à
> ê î ç à
> 
> 
> 
> 
> 
> 
> Thank you for your help.
> 
> 
> 
> 
> 
> Stefano Bagnara a écrit :
>> You should provide more informations.
>>
>> What "010203040506070809" become "1" ??
>>
>> Please post the full source of the mail you post (there is no
>> 010203040506070809 in the 2 headers you posted) and any change you did
>> to the default configuration.
>>
>> Stefano
>>
>> Thibaut wrote:
>>> Hi
>>>
>>> I use james-2.2.0 and MySQL 4.1.12.
>>>
>>> I record incoming mail in the DB but "010203040506070809" become "1"
>>>
>>> The mail i post is :
>>>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>> Content-Transfer-Encoding: 7bit
>>>
>>>
>>> And the database is MySQL:* *UTF-8 Unicode
>>>
>>> How can i solve this problem ? 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


Re: UTF6 Iso-8859-1

Posted by Thibaut <la...@ifrance.com>.
here is the mail i send :

>From - Fri May 12 15:01:48 2006
X-Mozilla-Status: 0001
X-Mozilla-Status2: 00800000
Message-ID: <44...@cvdunet.com>
Date: Fri, 12 May 2006 15:01:43 +0200
From: Thibaut Lassalle <tl...@cvdunet.com>
User-Agent: Thunderbird 1.5 (X11/20051201)
MIME-Version: 1.0
To:  post19@posteone.com
Subject: essai
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

010203040506070809
010203040506070809
010203040506070809

ê î ç à
ê î ç à





I put a System.out.println() to see what is received :

\01\02\03\04\05\06\07\08\09^M
\01\02\03\04\05\06\07\08\09^M
\01\02\03\04\05\06\07\08\09^M
^M
ê î ç à^M
ê î ç à



But here is what i have in my mysql (via phpMyAdmin 2.6.2-rc1) :



1




ê î ç à
ê î ç à






Thank you for your help.





Stefano Bagnara a écrit :
> You should provide more informations.
>
> What "010203040506070809" become "1" ??
>
> Please post the full source of the mail you post (there is no
> 010203040506070809 in the 2 headers you posted) and any change you did
> to the default configuration.
>
> Stefano
>
> Thibaut wrote:
>> Hi
>>
>> I use james-2.2.0 and MySQL 4.1.12.
>>
>> I record incoming mail in the DB but "010203040506070809" become "1"
>>
>> The mail i post is :
>>
>> Content-Type: text/plain; charset=ISO-8859-1
>> Content-Transfer-Encoding: 7bit
>>
>>
>> And the database is MySQL:* *UTF-8 Unicode
>>
>> How can i solve this problem ? 


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


Re: UTF6 Iso-8859-1

Posted by Stefano Bagnara <ap...@bago.org>.
You should provide more informations.

What "010203040506070809" become "1" ??

Please post the full source of the mail you post (there is no 
010203040506070809 in the 2 headers you posted) and any change you did 
to the default configuration.

Stefano

Thibaut wrote:
> Hi
> 
> I use james-2.2.0 and MySQL 4.1.12.
> 
> I record incoming mail in the DB but "010203040506070809" become "1"
> 
> The mail i post is :
> 
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
> 
> 
> And the database is MySQL:* *UTF-8 Unicode
> 
> How can i solve this problem ?
> **
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org