Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Comparación de Collations general-spanish-spanish2 en MySQL
// Comparación de Collations general-spanish-spanish2 en MySQL drop table if exists CollationTest; create table CollationTest ( texto varchar(50) not null ); insert into CollationTest (texto) values ('lana'), ('llano'), ('lazy'), ('nora'), ('ñoño'), ('Manita'), ('Mamá'), ('gato'),('Güero'),('gusano'), ('cena'),('chino'),('cinco'); select texto as general from CollationTest order by texto collate utf8_general_ci; select texto as spanish from CollationTest order by texto collate utf8_spanish_ci; select texto as spanish2 from CollationTest order by texto collate utf8_spanish2_ci; drop table CollationTest;
run
|
edit
|
history
|
help
0
ITM_14210069
Funciones Cadena
daily score
rtufgy
new_road
daily score
ebac_brms_bus_Details
Simon_Test1
exp11
pt.stackoverflow.com/questions/170610