Jeroen Geilman ha scritto:
> On 1/25/11 1:16 PM, Mark Martinec wrote:
>>> How does MySQL know that the query parameter(s) should be UTF-8
>>> and not ISO LATIN mumble or something else?
>> By a client executing a command:
>> SET NAMES 'utf8'
>> as far as I can tell.
>>
>> SET NAMES indicates what character set the client will use
>> to send SQL statements to the server.
>> http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
>>
>> Mark
>
> True; however, this still doesn't yield the desired result if the
> table/column character set isn't UTF-8.
>
> IFF client_charset == table_or_column_charset == UTF-8, then yes.
>
> You could retrieve that charset value from the information_schema, but
> it would be costly to do this for every query.
>
> If you're setting up a mysql map, you should probably be aware of
> these possible issues and adjust either the table or the query
> accordingly.
>
Uhm, i have another information about that case: the mail are sended to
postfix from an antispam appliance (Symantec). Can be a problem of
config of that antispam results illegal characters are sended to postfix?
Anyway, here is my conf
user = postfix
password = xxxxxxxxxxxx
hosts = 127.0.0.1
dbname = postfix
table = domain
select_field = transport
where_field = domain
Can i add something to solve that problem?
Cordially,
Claudio Prono.
--
--------------------------------------------------------------------------------
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
