0003203: SET NAMES 'utf-8', VARCHAR string truncation

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0003203

[Quercus]

minor

always

12-29-08 12:15

01-03-09 13:43

Reporter

nam

View Status

public

Assigned To

ferg

Priority

high

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

4.0.0

Product Version

4.0.0

Product Build

Summary

0003203: SET NAMES 'utf-8', VARCHAR string truncation

Description

(rep by M. Schmidt)

<?php

$db = mysql_connect();
mysql_query("CREATE DATABASE test");
mysql_select_db("test");

mysql_query("DROP TABLE test");
mysql_query("CREATE TABLE test (a VARCHAR(10), b BLOB(10))");
mysql_query("SET NAMES 'utf8'");

mysql_query("INSERT INTO test VALUES ('\xC2\xA2', '\xC2\xA2')");
$result = mysql_query("SELECT * FROM test");

$array = mysql_fetch_assoc($result);
var_dump(bin2hex($array["a"]));
var_dump(bin2hex($array["b"]));

?>

results:
string(2) "a2"
string(4) "c2a2"

expected results:
string(4) "c2a2"
string(4) "c2a2"

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0003689) ferg 01-03-09 13:43	php/1468

Issue History
Date Modified	Username	Field	Change
12-29-08 12:15	nam	New Issue
01-03-09 13:43	ferg	Note Added: 0003689
01-03-09 13:43	ferg	Assigned To	=> ferg
01-03-09 13:43	ferg	Status	new => closed
01-03-09 13:43	ferg	Resolution	open => fixed
01-03-09 13:43	ferg	Fixed in Version	=> 4.0.0

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.