For Programmers: Free Programming Magazines  


Home > Archive > PHP Documentation > April 2007 > #41168 [Opn->Bgs]: Default Charset problem for MySQL









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author #41168 [Opn->Bgs]: Default Charset problem for MySQL
derick@php.net

2007-04-23, 3:59 am

ID: 41168
Updated by: derick@php.net
Reported By: roleroz at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: Documentation problem
Operating System: Gentoo Linux
PHP Version: Irrelevant
New Comment:

File a report with the Gentoo maintainers for doing something not
standard (again).


Previous Comments:
------------------------------------------------------------------------

[2007-04-23 03:29:11] ljbuesch at purdue dot edu

From the MySQL manual
(http://dev.mysql.com/doc/refman/5.0...set-syntax.html):
---
By default, MySQL uses the latin1 (cp1252 West European) character set
and the latin1_swedish_ci collation that sorts according to
Swedish/Finnish rules. These defaults are suitable for the United States
and most of Western Europe.
---

Your system must be compiled to not use latin1, but it is in no way a
PHP documentation problem.

------------------------------------------------------------------------

[2007-04-23 03:12:47] roleroz at gmail dot com

Description:
------------
At the documentation it says that the default charset for mysql is
latin, but in my system that doesn't seem to be right.

After checking lots of posibilities, i set the mysql.connect_charset
variable, at php.ini, to latin1, and my code finally worked

It seems that the default charset for mysql functions in php 5.2.1
running over apache2 it's utf8



------------------------------------------------------------------------


--
Edit this bug report at http://bugs.php.net/?id=41168&edit=1
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com