Re: [PHP-DB] French and Spanish Accent Letters
I use utf-8 for that it works well Bastien Koert 905-904-0334 Sent from my iPhone On 2010-11-10, at 10:03 AM, "Ron Piggott" wrote: > > I have a column that is VARCHAR 250. I need it to be able to accept french > and spanish accents. The purpose of the column is organization names. The > “Collation” default is “latin1_swedish_ci” What do I need to do? Ron > > The Verse of the Day > “Encouragement from God’s Word” > http://www.TheVerseOfTheDay.info -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] French and Spanish Accent Letters
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
Re: [PHP-DB] French and Spanish Accent Letters
On Wed, Nov 10, 2010 at 10:16, Ron Piggott wrote: > > I did Daniel --- php-db@lists.php.net ; Thank you for telling me about the > mySQL list. > > I failed to mention in my original e-mail the database is mySQL. My fault. Force of habit mentioning the php-db@ list. Sorry if there was any confusion on that. In any case, you'll probably get exactly the answer you're trying to find on the MySQL list. Quite possibly quicker there than the php-db@ list as well. -- Network Infrastructure Manager Documentation, Webmaster Teams http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] French and Spanish Accent Letters
I did Daniel --- php-db@lists.php.net ; Thank you for telling me about the mySQL list. I failed to mention in my original e-mail the database is mySQL. The Verse of the Day “Encouragement from God’s Word” http://www.TheVerseOfTheDay.info -Original Message- From: Daniel Brown Sent: Wednesday, November 10, 2010 10:08 AM To: Ron Piggott Cc: php-db@lists.php.net Subject: Re: [PHP-DB] French and Spanish Accent Letters On Wed, Nov 10, 2010 at 10:03, Ron Piggott wrote: I have a column that is VARCHAR 250. I need it to be able to accept french and spanish accents. The purpose of the column is organization names. The “Collation” default is “latin1_swedish_ci” What do I need to do? Ron You need to ask on a database list. If it's MySQL, blast it to my...@lists.mysql.com, or - regardless of database - you can send it to php...@lists.php.net. -- Network Infrastructure Manager Documentation, Webmaster Teams http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] French and Spanish Accent Letters
On Wed, Nov 10, 2010 at 10:03, Ron Piggott wrote: > > I have a column that is VARCHAR 250. I need it to be able to accept french > and spanish accents. The purpose of the column is organization names. The > “Collation” default is “latin1_swedish_ci” What do I need to do? Ron You need to ask on a database list. If it's MySQL, blast it to my...@lists.mysql.com, or - regardless of database - you can send it to php...@lists.php.net. -- Network Infrastructure Manager Documentation, Webmaster Teams http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php