Párrafo acentuado: áéíóú en archivito grabado como utf8


SELECT * FROM t1 WHERE a='' ORDER BY a
t1

SELECT a.a, b.a FROM t1 a JOIN t2 b WHERE a.a=b.a ORDER BY a.a
t1

SELECT a, LENGTH(a), CHAR_LENGTH(a), HEX(a) FROM t1 ORDER BY a

gIAsql=
Array
(
    [host] => localhost
    [port] => 3306
    [user] => root
    [pwd] => M@chiavell1
    [dbname] => chars
    [socket] => /lamp/mysql/mysql.sock
    [set_autocommit] => 
    [pconnect] => 
    [init] => Array
        (
            [0] => SET NAMES 'utf8' COLLATE 'utf8_general_ci'
        )

    [trace] => 
    [sql_trace] => Array
        (
        )

    [link] => 
    [err] => 
  • 1146 Table 'quantix.t1' doesn't exist
    SELECT * FROM t1 WHERE a='' ORDER BY a
  • 1146 Table 'quantix.t1' doesn't exist
    SELECT a.a, b.a FROM t1 a JOIN t2 b WHERE a.a=b.a ORDER BY a.a
  • 1146 Table 'quantix.t1' doesn't exist
    SELECT a, LENGTH(a), CHAR_LENGTH(a), HEX(a) FROM t1 ORDER BY a [selected_rows] => 0 [begins] => 0 [affected_rows] => 0 [dont_quote] => Array ( [0] => NULL [1] => CURDATE() [2] => CURRENT_DATE() [3] => CURRENT_DATE [4] => CURRENT_DATETIME [5] => CURRENT_TIME() [6] => CURRENT_TIME [7] => CURTIME() [8] => CURRENT_TIMESTAMP() [9] => CURRENT_TIMESTAMP [10] => NOW() [11] => LOCALTIMESTAMP [12] => LOCALTIMESTAMP() [13] => SYSDATE() [14] => UNIX_TIMESTAMP() [15] => UTC_DATE() [16] => UTC_TIME() [17] => UTC_TIMESTAMP() ) [id_registro] => 0 [errno] => 1146 [error] => Table 'quantix.t1' doesn't exist [sql_error] => SELECT a, LENGTH(a), CHAR_LENGTH(a), HEX(a) FROM t1 ORDER BY a )