Manual @ PIPNI - Databases - How to deal with displaying Czech symbols in records fetched from MySQL (4.1+)?

FAQ

manual.pipni.com > Databases | Search | Problems?

How to deal with displaying Czech symbols in records fetched from MySQL (4.1+)?
If there are malformed Czech symbols appearing on your webpage, you are probably fetching them in a different encoding than you expect. Try setting this for every connection ({desired encoding} gets replaced with e.g. cp1250):

  mysql_query("SET character_set_results={desired encoding}");
  mysql_query("SET character_set_connection={desired encoding}");
  mysql_query("SET character_set_client={desired encoding}");

or you can simplified

  mysql_query("SET NAMES '{desired encoding}'");

which will set these three variables.

Total count of tips: 141