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
  • 16,580
  • 5
  • 54
  • 111
Alvin
  • 8,219
  • 25
  • 96
  • 177
  • "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