1
Peekay
MySQL 3.32 to 4.1 - anyone know the correct charset and collation settings?
  • 2005/6/9 18:36

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


I want to check out XOOPS using PHP 5, so I just installed Xampp on a laptop running WinXP Home Edition.

My problem is, the package comes with MySQL 4.1.11. When I went to set up a new DB and import a SQL file, I found PHPMyAdmin presented me with options for language, character set and collation. I did some research, but I confess the technical explanation of these options is beyond me.

Anyone got a dummy's guide to setting these options in order to import a MySQL 3.32 dump into MySQL 4.1 properly? Or do I just leave them alone?

BTW, the Xampp set up was very quick. Double-clicked the installer and it all worked (very rare!).

2
m0nty
Re: MySQL 3.32 to 4.1 - anyone know the correct charset and collation settings?
  • 2005/6/9 18:50

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


latin1 usually works or utf-8

3
tedsmith
Re: MySQL 3.32 to 4.1 - anyone know the correct charset and collation settings?
  • 2005/6/9 19:34

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


phpMyAdmin uses Latin for it's backups, so when you restore you have to specify latin1 as the restore type, not UTF which it (MySQL) will default to.

4
Peekay
Re: MySQL 3.32 to 4.1 - anyone know the correct charset and collation settings?
  • 2005/6/9 22:32

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Thx for the info guys. (top marks for the Derbyshire Xoopsters!)

Login

Who's Online

242 user(s) are online (126 user(s) are browsing Support Forums)


Members: 0


Guests: 242


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits