|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?