SEO

#1 (**permalink**) 02-28-2008, 10:32 AM

Hi there guys,

My doubt is, what's the best way of storing text into a mysql
database, if the text has special characters.. imagine iso-8859-1.

Something similar to a site that's visited by users with different
nationalities and they insert text into database with different
language charsets?

A few guys already told me that it's important to save the raw data,
and convert it before display.

Should I set mysql settings all to utf8?

* mysql charset
* mysql connection collation
* table collation's

At witch point should I convert it and to what?

Need some help on this one, thanks in advance.

#2 (**permalink**) 02-28-2008, 10:32 AM

On Jan 28, 1:38 pm, "João Morais" <jcsmor...@gmail.com> wrote:
> Hi there guys,
>
> My doubt is, what's the best way of storing text into a mysql
> database, if the text has special characters.. imagine iso-8859-1.
>
> Something similar to a site that's visited by users with different
> nationalities and they insert text into database with different
> language charsets?
>
> A few guys already told me that it's important to save the raw data,
> and convert it before display.
>
> Should I set mysql settings all to utf8?
>
> * mysql charset
> * mysql connection collation
> * table collation's
>
> At witch point should I convert it and to what?
>
> Need some help on this one, thanks in advance.

You can view different mysql collation sets here (this way you can see
what characters are supported and how they are sorted):
http://www.collation-charts.org/mysql60/
I also recommend that you read this: http://dev.mysql.com/doc/refman/5.1/en/charset.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

MySQL Charset/Collation problems