FUDforum: comp.lang.php » PHP, MySQL and UTF-8?

Home » Imported messages » comp.lang.php » PHP, MySQL and UTF-8?

Show: Today's Messages :: Polls :: Message Navigator

Re: PHP, MySQL and UTF-8? [message #175375 is a reply to message #175374]

Mon, 12 September 2011 20:27

A
Messages: 17
Registered: June 2011

Karma:

Junior Member

1. Your <head> must have this:

<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
</head>

2. If you load from template file and then print, your template file must be
saved in UTF-8 (I'm not sure if BOM must be present, try with or without
it) - UTF8 BOM is 0xEF 0xBB 0xBF - http://unicode.org/faq/utf_bom.html#bom1

3. Execute these queries before querying database rows (only once is
needed):

SET CHARACTER SET utf8;
SET NAMES utf8;

4. After the two above you should be able to retrieve them properly and
print them as the should be.

Does that help?

Report message to a moderator

[Message index]

		PHP, MySQL and UTF-8? By: Robert Latest on Mon, 12 September 2011 16:46
		Re: PHP, MySQL and UTF-8? By: Jerry Stuckle on Mon, 12 September 2011 19:30
		Re: PHP, MySQL and UTF-8? By: Peter H. Coffin on Mon, 12 September 2011 19:31
		Re: PHP, MySQL and UTF-8? By: A on Mon, 12 September 2011 20:27
		Re: PHP, MySQL and UTF-8? By: Thomas 'PointedEars' on Tue, 13 September 2011 14:53

Previous Topic:	Re: Startup City 2011 (September 24th,Mumbai)
Next Topic:	Social Bookmarks Script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 08:27:49 GMT 2024

Total time taken to generate the page: 0.04224 seconds