|
Mantis - Quercus
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 3203 | minor | always | 12-29-08 12:15 | 01-03-09 13:43 | |
|
|
|||||
| Reporter: | nam | Platform: | |||
| Assigned To: | ferg | OS: | |||
| Priority: | high | OS Version: | |||
| Status: | closed | Product Version: | 4.0.0 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 4.0.0 | ||
|
|
|||||
| 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: | |||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||