>-----Original Message----- >From: Mike Blezien [mailto:[EMAIL PROTECTED] >Sent: Sunday, November 23, 2008 4:59 PM >To: MySQL List >Subject: Special Characters > >Hello, > >we are in the process of setting up a database with members data and >other info. >We'll need to enter names with special characters, i.e: > >apostrophes: O'Rourke >tildes: Magglio Ordóñez >titlo: Anaïs >hyphen: Chun-Myers > >Is there some special table setup required, collation or storage engine, >in >order to enter data like this or can this be handled with our >programming, Perl? >Where using MySQL 5.0.51 > [JS] For the most flexibility, I suggest you use utf8_general_ci as the default for your entire database. That's what we use, and it will swallow just about anything (including Chinese).
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]