1
wizanda
What default charcter sets, can you use for mysql?
  • 2005/7/5 19:40

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


I am currently moving my site and the site i am moving to has Collation?

What is it? do they need it? as it is a friends server

What should i use as my default charter set, to run XOOPS on or does it matter?

Also if it isn't needed and it is mainly english sites should i get them to switch off Collation?

2
rowdie
Re: What default charcter sets, can you use for mysql?
  • 2005/7/10 8:39

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


All character sets in MySQL have a default collation. Normally you won't need to change it. latin1 is the default character set for MySQL and latin1_swedish_ci is the default collation for latin1. I wouldn't change it unless you are really having problems displaying characters.

When moving from one MySQL database to another just make sure the character set of the new database is the same as the original. Data which is stored in one character set will probably become corrupted if you import it to a database that uses a different one, unless you convert it - I have no experience with this, just going from what I remember reading in the MySQL manual.

Login

Who's Online

499 user(s) are online (414 user(s) are browsing Support Forums)


Members: 0


Guests: 499


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