French and Spanish Accent Letters

------=_NextPart_000_0015_01CB80BE.97A0A3E0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable


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 â€=9CCollationâ€=9D default is =
â€=9Clatin1_swedish_ciâ€=9D What do I need to do? Ron

The Verse of the Day
â€=9CEncouragement from Godâ€=99s Wordâ€=9D
http://www.TheVerseOfTheDay.info
------=_NextPart_000_0015_01CB80BE.97A0A3E0--

Re: French and Spanish Accent Letters

On Wed, Nov 10, 2010 at 10:03, Ron Piggott
wrote:
>
> I have a column that is VARCHAR 250. =A0I need it to be able to accept fr=
ench and spanish accents. =A0The purpose of the column is organization name=
s. =A0The =93Collation=94 default is =93latin1_swedish_ci=94 =A0What do I n=
eed to do? =A0Ron

You need to ask on a database list. If it's MySQL, blast it to
mysql@lists.mysql.com, or - regardless of database - you can send it
to php-db@lists.php.net.

--=20

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: 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
mysql@lists.mysql.com, or - regardless of database - you can send it
to php-db@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: 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: French and Spanish Accent Letters

Hi Ron, you should use

CHARSET=3Dutf8 COLLATE=3Dutf8_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=3DInnoDB DEFAULT CHARSET=3Dutf8 COLLATE=3Dutf8_unicode_ci;

Cheers.

--=20
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: 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" w=
rote:

>=20
> I have a column that is VARCHAR 250. I need it to be able to accept frenc=
h and spanish accents. The purpose of the column is organization names. Th=
e â€=9CCollationâ€=9D default is â€=9Clatin1_swedish_ciâ€=9D=
What do I need to do? Ron
>=20
> The Verse of the Day
> â€=9CEncouragement from Godâ€=99s Wordâ€=9D
> http://www.TheVerseOfTheDay.info

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