Setting charset and collation on every query, is it neccessary and can I suppress it?

[eluser]OwenM[/eluser]
Hi,

Tried that, I converted the tables to utf8 and utf8_general_ci using:

Code:

ALTER TABLE tz_inner_polygons CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

for each table, restarted to mysqld service but I still get the following in my query log?

Code:

110328  8:41:50         14 Init DB     myDB
             14 Query       SET NAMES 'utf8' COLLATE 'utf8_general_ci'
110328  8:41:51          9 Init DB     myDB
              9 Query       SET NAMES 'utf8' COLLATE 'utf8_general_ci'
              9 Query       select * from tz_outer_polygons where min_lat<=52.400000 and max_lat>=52.400000 and min_lon<=-8.480000 and max_lon>=-8.480000
              9 Query       select * from tz_info where location_id="IE"

Any suggestions? It's the two SET NAMES statements that I think are unneccessary and want to prevent.

Tks,
Owen.