For example, sorted in traditional Spanish order:
SQL>SELECT chardata FROM t ORDER BY chardata COLLATE spanish_traditional_3;
Observe that character data uses the ISO/IEC 8859-1 (Latin-1) encoding. If your data have used another encoding, you must translate it to Unicode and use the NCHAR datatype instead.