Re^2: locales, encodings, collations, charsets... how can I match a given MySQL collation?

Slight clarification: I don't know about other RDBMS products, but in MySQL's case, the sorting is only dependent on the column's collation, which is easy to find with SHOW FULL COLUMNS. If my tool discovers that the two columns have different collations, I think it will have to die with an error.

Comment on Re^2: locales, encodings, collations, charsets... how can I match a given MySQL collation?

Replies are listed 'Best First'.
Re^3: locales, encodings, collations, charsets... how can I match a given MySQL collation? by varian (Chaplain) on Apr 02, 2007 at 13:41 UTC
Note that even in MySQL if not defined explicitly collation will be dependent upon collation settings for database and if that is default then even upon collation for server instance. BTW the handling of collation is vendor dependent so if you want to stick to vendor-neutral DBI then you don't want to count on it.	[reply]


Welcome to the Monastery
	PerlMonks