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”
On Wed, Nov 10, 2010 at 10:03, Ron Piggott
ron.pigg...@actsministries.org 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
On Wed, Nov 10, 2010 at 10:16, Ron Piggott
ron.pigg...@actsministries.org 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.
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
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 ron.pigg...@actsministries.org
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
