View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0005767mantisbtbugtrackerpublic2005-06-10 09:532008-10-18 18:34
Reportercomargo Assigned Tograngeway  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.0a3 
Summary0005767: Win32 MySQL 4.1.12a-nt default character set
Description

Default charset for libMySQL.dll set to 'latin1'.
When tried to add note using (e.g.) russian characters text was saved to database as 'question marks'.
As temporary "dirty hack", I've added next line to _connect() and _pconnect() functions of core\adodb\drivers\adodb-mysql.inc.php file:

mysql_query("SET CHARACTER SET cp1251",$this->_connectionID);

I think that correct fix should use SetCharSet() function of core\adodb\adodb.inc.php that should be extended to mysql (currently it used only for interbase, postgres and oci8, as mentioned in core\adodb\adodb.inc.php) and this function should be used in mantis code.
Another way is to switch project to utf8 (0004084) and don't forget to set character set of connection to utf8 too.

Additional Information

http://www.php.net/manual/en/ref.mysql.php#mysql.installation.notes
http://dev.mysql.com/doc/mysql/en/charset-connection.html

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
related to 0004084 closedsiebrand [all lang] Use UTF-8 codepage 

Activities

extrealm

extrealm

2006-01-08 15:37

reporter   ~0011888

Is there any better workaround? I did similar hack on /core/database_api.php by inserting <code>$g_db->Execute("set names utf8")</code> after connection.
grangeway

grangeway

2008-05-04 06:25

reporter   ~0017764

Thank you for taking the time to report a problem with mantis.

The Latest codebase(s) already include functionality to send the SET NAMES line.

Unfortunately you are not using the latest version and the problem might already be fixed. Please download the latest release from http://www.mantisbt.org/download.php

If you are able to reproduce this bug in the current release, or have some more information on how this feature could be improved in the current release. Please either change the mantis version on this bug report
to the version you tested and change the status back to "Open", or open a new issue report wit more information.

Again, thank you for your bug report and your continued support.
Paul