The Websites Continued

Posted by KaBob799 on Sept. 22, 2009, 5:05 p.m.

Its time for another round of php/mysql related questions! Actually… I only have one.

My sites currently store basic text perfectly but foreign characters often come out incorrect. I've tried out a few different methods and only 1 came close to getting it right.

I really need to find out the functions to run before inserting it into the database and the functions to run before echoing.

I tried googling it, but maybe I just dont know the keywords to use because nothing useful came up. They are all unrelated issues or assume you already know what your doing and just need help with some small detail =/

I guess this is the disadvantage of self-teaching yourself php on a need-to-know basis and then trying to do something huge =p

Anyway, game stuff:

Work continues on Pokemon Twilight. The next demo should easily be done by Halloween. We've started re-adding the forum integration where you connect to your forum account to upload pokemon and stuff. It also replaces the friend code system with usernames so connecting to friends is much simpler.

Comments

KaBob799 15 years, 3 months ago

Į ågrëê pãñthèøn

SteveKB 15 years, 3 months ago

why'd you post all those wierd letters up thar maybe you need a language pack or something

Rusky 15 years, 3 months ago

You need to use the right encoding. MySQL generally uses latin-1 or something by default, just change it to UTF-8 and make sure PHP is keeping its input that way. You could also use UTF-16 or any other Unicode encoding if you wanted.

MMOnologueguy 15 years, 3 months ago

You should fix 64digits's problem with triforcing.

  ▲

▲ ▲

sirxemic 15 years, 3 months ago

Quote: MMORPGuy
You should fix 64digits's problem with unicode.
Fix'd

Alert Games 15 years, 3 months ago

Yeah the database may use latin1_swedish by default. unicode would do it like Rusky said. just change it in the encoding of the base. or the collation of a collumn.

KaBob799 15 years, 3 months ago

It turns out I had to add an html meta tag to set the pages encoding.