column names with special characters

[Thomas Finninger]

i want to use mysql for logging perposes ...
the database will be accessed by a third party product using ODBC

the problem:

i'll have to create some columns with special characters in the column names

example:

create table PacketFilterLog (
PFlogDate datetime,
PFlogTime datetime,
SourceAddress varchar(25),
DestinationAddr ess varchar(25),
Protocol varchar(8),
`Param#1` varchar(8),
`Param#2` varchar(8),
TcpFlags varchar(255),
FilterRule varchar(16),
Interface varchar(25),
IPHeader varchar(255),
Payload varchar(255)
);
the proplem resides in:
`Param#1` varchar(8),
`Param#2` varchar(8),

mysql 4.0.16-nt does not accept these column names (and they have to be this way!)

looking at the mysql reference http://www.mysql.com/doc/en/Legal_names.html
this actually should work ...

any idea ?