BigBrother
Programmer
I'm trying to build a mySQL database around 2 years of historical stock quotes for all tickers on nyse. The problem is some stocks use funny characters in their ticker symbols and company names (i.e., CD~ is one symbol). When I try to create table names and add records with these characters included, mySQL returns an error. I tried using the ' character to convert these to literals (i.e., CREATE TABLE 'CD~' (field_01 INT, field_02 CHAR(50)); ), but mySQL still doesn't like it. Any ideas?