I'm a Vietnamese. I'm a newbie for ee2. When I enter "Nước ngập mái nhà sau cơn bão" in Title field, EE2 automatically generates "nc-ngp-mai-nha-sau-cn-baeo" in URL Title. That isn't correct. I need "nuoc-ngap-mai-nha-sau-con-bao" in my URL Title. I created my database with "utf8-general-ci" collation. May somebody help me?. Thanks.
As far as I'm aware no. Because EE will strip out the non-alpha numeric characters, not replace them with their similar counterparts. It's not relevant to the Database.
So either you have to manually edit the url_title field each time or look at other options. But in looking elsewhere for solutions may give you an even better end result - of being able to use your language correctly in URLs (better for your users and better for SEO).
I touch briefly on it here, but you can utilise a custom field for the url but you can't then use the native and automatic method of channel:entries, so will need to use search:custom_url="nước-ngập-mái-nhà-sau-cơn-bão" dynamic="no" parameters in the channel entries tag. Your URL would then look something like this:
With the 'content' group, index.php template catching this URL.
Alternatively (although I've not had the chance to use it), the Publisher add-on allows for multi-language URLs, so this should simplify the whole process if your budget can stretch.