Reindl Harald ha scritto:
> I think this can be a problem and would recommend to
> force UTF8 for all tables, if there are only LATIN1 data
> they should not be touched in any way and if all is UTF8
> there is no point of mixing
>
> Well, normally we use LATIN1 historical for some thounsand
> tables but the whole database for postfix/dovecot/dbmail is
> is UTF8 from the beginning
>
>
I really don't know if can be this the problem. On a similar server,
with the same situation, there are no problems at all.
The point, if you look at my previous mail is:
Two questions:
- How i can force UTF8 for all the tables?
- If i change all into UTF8, can be some data loss or some risk at all?
Cordially,
Claudio Prono.
> Am 24.01.2011 11:53, schrieb Claudio Prono:
>
>> Reindl Harald ha scritto:
>>
>>> show create table tablename;
>>>
>>>
>>>
>> Ok, something strange is come out.
>>
>> Here is the list of tables on postfix database:
>>
>> +-----------------------+
>> | Tables_in_postfix |
>> +-----------------------+
>> | admin |
>> | alias |
>> | alias_domain |
>> | config |
>> | domain |
>> | domain_admins |
>> | fetchmail |
>> | log |
>> | mailbox |
>> | quota |
>> | quota2 |
>> | vacation |
>> | vacation_notification |
>> +-----------------------+
>> 13 rows in set (0.00 sec)
>>
>> All the tables have as default charset "latin1" except for
>> "vacation_notification". That is "DEFAULT CHARSET=utf8"
>>
>> My system is an OpenSuSE 11.2, and mysql is mysql-5.1.49-0.1.1.x86_64.
>>
>> Can be this the problem ? I have checked this into another similar
>> server, and the results are the same... all the tables are latin1,
>> except for "vacation_notification", wich is "utf8", but there is no
>> trace of this problem on the other server......
>>
>> Any idea?
>>
>> Cordially,
>>
>> Claudio Prono.
>>
>>
>
>
> ------------------------------------------------------------------------
>
> !DSPAM:1,4d3d5faa289601786021290!
--
--------------------------------------------------------------------------------
Claudio Prono OPST
System Developer
Gsm: +39-349-54.33.258
@PSS Srl Tel: +39-011-32.72.100
Via San Bernardino, 17 Fax: +39-011-32.46.497
10141 Torino - ITALY http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc
