SEO

hi,

by now i've used mysql 4.0 now i have to switch to 5.0. my problem is that the
old databases are in latin1 and all my php code does not care about character
sets as it just used to work ...

i was able to load the datat to mysql 5.0 with latin1 encoding. aleast mysql
shows latin1 as characterset for my tables. but php connects with UTF-8 and
the default character set i UTF-8 too. i've tried to set the session charset
to latin1 without success.

so here are my questions:

1. is ist possible to switch mysql 5.0 completely to UTF-8 ?

2. an option would be to convert my data from latin1 to UTF-8
how can i do this ?

TIA
matthias

On Wed, Feb 28, 2007 at 09:39:40AM +0100, Matthias Henze wrote:
> hi,
> 1. is ist possible to switch mysql 5.0 completely to UTF-8 ?

Yes.

>
> 2. an option would be to convert my data from latin1 to UTF-8
> how can i do this ?

Export your 4.x databse with mysqldump and convert it with iconv.

Greetings
Mario

--
-----------------------------------------------------
| havelsoft.com - Ihr Service Partner für Open Source |
| Tel: 033876-21 966 |
| Notruf: 0173-277 33 60 |
| http://www.havelsoft.com |
| |
| Inhaber: Mario Günterberg |
| Mützlitzer Strasse 19 |
| 14715 Märkisch Luch |
-----------------------------------------------------

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iQIVAwUBReVSFjUZahlMISn3AQL42g//ToSX4g2YrzrXuWhhoRK5ld9ge7t1Uc2O
ru3f2YxMUbQkXH0fpg07bf+RlAS29ycnw7dE+RjPIzQpKolMg7 NSrlRZSsycw7LO
BzX91d5DVs6axPuJDJNL7Anf23mZHDDemlxaY3K0ru87UFuKwk tPcNwEjIuLSgNR
k6qaHg02OwArvNvgFCQiQ+9U7Smu5LDnMMS0uciUbp+D6ZXtFZ B8dRlXL/C8MSOo
rb9Xj02HS5dsE1Yruzi/vD5IMzHIvCIcrG1/qImflkrBwTLHgdjltyeLQxo8TUee
i0Q3el5TxMuX4FTw6H5LFGY+JsipKCMIK3AHgm3FcFjzniFpXi/6y/WiyBa3t+nc
t54u67hNk9ZWLF4X8szzE/d/0yctSTZ7DA8xdyAQuyGQqYuTj9B7PN9fjjN1Jh6s
xOVpsZlKfiXc3szHGqyt1cr96WLbsI6XEpmTcNBdsyGtEC2H/See11730x0VCA+d
z/Yn42uKsz4s0TA6voK6gdqaoMhfjgtijGJSluA6zK755te0+heZ v7JjXDOeuD3i
la7VBks5zi+zkgM+XMI/2e2o+4kFJhFJYsgQKnW5YSvTVayhXxRENoDC8dxQcguP
AbCCnn72T7czoD/utcJbFd1mEDf5uo7fz1JjXBRe4YPVWcV41JdYWNlBt2EwUtuK
5eCSpHM3bpc=
=f/Jk
-----END PGP SIGNATURE-----