Lost with Charsets and Collations
Posted by:
reg_forum
Date: July 08, 2007 06:29AM
Hi guys,
I've always stored English, French and Japanese text strings in my databases without paying much attention to mysql charsets and collations. Since I've never noticed any problem, I'm wondering: what are they for? ( I've read the documentation but it's obviously targeted to experienced admins ... so I'm still clueless )
This week, I've installed the new version of mysql on my windows box (AppServ install) and I accidentally set default-character-set to UTF-8. Now, when I use SQLyog, all my fields have the collation field set to UTF-8 ( all my web pages are encoded in ISO or JIS).
Will this change have any bad repercussion?
What should I do to have my database safely store any language from a non-UTF-8 website?
Is it ok to leave the collation fields blank?
Many many thanks to the ones who will share some hints :)
Subject
Views
Written By
Posted
Lost with Charsets and Collations
2913
July 08, 2007 06:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.