Re: French and Spanish Accent Letters

[AndrÃs G. MontaÃez <andresmontanez@xxxxxxxxx>]

Hi Ron, you should use

CHARSET=utf8 COLLATE=utf8_unicode_ci

in your table for a wide option of languages.

Example:

CREATE TABLE  `t_my_table` (
  `row_id` int(10) unsigned NOT NULL,
  `row_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Cheers.

-- 
AndrÃs G. MontaÃez
Zend Certified Engineer
Montevideo - Uruguay

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php