Re: utf8, 4.1, and character length truncation in mysql system tables

Hi! Normally, people will choose "lazy" method, define default charset as 'utf8'. But based on the information of mysql, one might be able to define at table level as 'utf-8' instead of whole database charset. In normal case, only certain table or certain "col" might store 'utf-8' data. Hence

if no lock at all for update

Hi! If there is no any lock at all while one update a row, what it is going to happen to my SQL database? In which cases, it might cause problems? Anyone know? Thanks __ Switch to Netscape Internet Service. As low as $9.95 a mont

RE: Chinese word not sort proper in 'order by'

I think they are sorted by how many draws each word has. Zhi "Shuming Wang" <[EMAIL PROTECTED]> wrote: > >mysql 4.1.x :Latin1, the select resualt is disorder: >shoud be axx > Â Â Â Â bxx > Â Â Â Â hhh > > Â Â Â Â Â ... > Â Â Â Â Âzxx > Â Â Â Â Âääæ > Â Â Â Â Âæé Â Â Â Â > Â Â Â Â Âéç > Â Â Â

RE: Unicode characters are giving me question marks

one has to encode "extend string or any unicode" to utf-8 first and then insert it to MySQL database 4.1 Most likely you did not encode them to utf-8. zhi peng "Steve Quezadas" <[EMAIL PROTECTED]> wrote: >Hey guys, > >I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work i

uninstall MySQL

Anyone knew how to uninstall old version of MySQL? Thanks __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar f