0

I have a currencies table, which have a column called name, which is the currency name, for example:

PYG = Paraguayan guaraní­ --but it is store in table as Paraguayan guaraní
STD = São Tomé and Príncipe dobra --but it is store in table as São Tomé and Príncipe dobra

What is Collation I can use to store these value?

shA.t
  • 15,880
  • 5
  • 49
  • 104
Alvin
  • 7,787
  • 23
  • 77
  • 164
  • "collation" is not about storing data, it's about comparing it. – zerkms Sep 13 '16 at 04:31
  • seems like you store utf8 strings when your database expects latin1 (or similar) you should set up your database connection correctly. for example: http://stackoverflow.com/questions/202205/how-to-make-mysql-handle-utf-8-properly – Jakumi Sep 13 '16 at 07:44

0 Answers0