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
prithwi
prova
Employee
sort players by sum of results
itm
Resta fechas_horas
busID
ITM_14210069
rtufgy
count time interval