Re: La ñ y MYSQL
| From: | Eduardo Zarate | Date: | Fri, 28 May 2004 19:03:22 +0000 |
| Subject: | Re: La ñ y MYSQL | ||
| References: | 1 2 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-49023@lists.php.net to get a copy of this message | ||
¿Deberas que no hay diferencia entre "n" y "ñ" ? ...
mysql> desc tablita;
+---------------+---------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+----------------+-------+
| id | int(11) | | | 0 | |
| valor1 | char(10) | YES | | NULL | |
| insercion | timestamp(14) | YES | | NULL | |
| actualizacion | timestamp(14) | YES | | 00000000000000 | |
+---------------+---------------+------+-----+----------------+-------+
mysql> select * from tablita;
+----+-----------+----------------+----------------+
| id | valor1 | insercion | actualizacion |
+----+-----------+----------------+----------------+
| 1 | Elvalor 1 | 20040514093830 | 20040514093303 |
| 2 | valor 2 | 20040514093306 | 20040514093306 |
| 3 | valor 3 | 20040514093309 | 20040514093309 |
| 4 | Valor 4 | 20040514125645 | 00000000000000 |
| 5 | la n | 20040528125733 | 20040528125733 |
| 5 | la ñ | 20040528125738 | 20040528125738 |
| 7 | la N | 20040528125748 | 20040528125748 |
| 8 | entreno | 20040528125818 | 20040528125818 |
| 8 | extraño | 20040528125824 | 20040528125824 |
+----+-----------+----------------+----------------+
9 rows in set (0.00 sec)
mysql> select * from tablita where valor1 like '%ñ%';
+----+---------+----------------+----------------+
| id | valor1 | insercion | actualizacion |
+----+---------+----------------+----------------+
| 5 | la ñ | 20040528125738 | 20040528125738 |
| 8 | extraño | 20040528125824 | 20040528125824 |
+----+---------+----------------+----------------+
2 rows in set (0.00 sec)
Sale y vale
Byte
Quoting Jorge 'ToRo' Martínez Mauricio <jorgem@gmail.com>:
> mysql no reconoce diferencia entre "n" y "ñ"
>
> a menos que el tipo de campo donde esta almacenado sea BLOB o BINARY
> (char/varchar)
>
> salut.
>
> --
> PHP Spanish Localization Talk Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.