Utf-8

Databases
1

Currently my tables in MySQL are set to latin1_swedish_ci

Is it “suicide” to use that?

My website is based in the US, and I don’t expect to go “International” anytime soon, but anything is possible?!

If I am concerned about limiting my website, should I switch to UTF-8 or whatever?!

Also, how could making a change from latin1-swedish_ci to utf-8 (or whatever) mess up my current SQL or PHP? (My code isn’t that involved, but might still break…)

Thanks,

Debbie

2

what happened when you tested it?

:smiley:

3

Mudslides in Southern California :cool:

Debbie

4

r937,

Maybe you could answer the first question since that drives all others…

Debbie

5

Supporting UTF-8 sounds like a lot of work and a pain…
http://us3.php.net/manual/en/mbstring.installation.php

Anyone have any practical experience using it?

Debbie

6

sure, no problem

nope, not at all

:cool:

7

Which UTF should I choose?

In phpMyAdmin there are a million different flavors of UTF-8 ?! :-/

Debbie

8

utf8_general_ci seems to work fine. That’s the one mine usually defaults to.

9