UTF-8 and latin1 collations in mysql

Continental Joined: 2004-06-14 Posts: 243	Posted: Mon, 2006-03-13 07:16
	I store by UTF-8 gallery tables in the mysql base with latin1 character set (collation). (I didn't invented it, that was a thing I didn't notice when installing gallery and gallery didn't ask). I'd prefer to store UTF-8 data in UTF-8 tables collation (mySQL > 4.1). The reasons for that are as follows: I could see normal characters in PhpMyAdmin and edit base directly (not so important) and search. Plese, tell me if search in case-sensitive for gallery when storing UTF-8 in latin1? If so, it is the second reason (important). At least, I faced this problem with drupal where my gallery is embed. How can I convert live gallery site (mySQL Database) with live data from latin1 to UTF-8 character set? and what I will tell gallery then that my collation has been changed in that case? Thank you.
	XUser login Username: * Password: * Create new account Request new password
valiant Joined: 2003-01-04 Posts: 32509	Posted: Tue, 2006-03-14 08:42
	- the G 2.0 -> G2.1 takes care of converting any non-utf8 mysql data to utf8 data - mysql search is always case-insensitive unless you use "binary" (text) fields.

XUser login