vote
2
検索エンジンでのインデックス生成に際してFirst Faved : Jul 04 2008 by ku0522Faved : 1 time with noteViewed : 1 timeFave It!

Faves for this Web page

  • ku0522 - Jul 04 2008 | MySQL

    コレーション。
    MySQL での文字列比較だと、データベースの性質上からも 1. のケースが圧倒的に多くて、utf8_unicode_ci とか、適当な collation を使うことで全角半角問題に対応できます。MySQL では strings/ctype-uca.c に書かれている実装になっています。
    Currently supports only subset of the full UCA:
    - Only Primary level key comparison
    - Basic Latin letters contraction is implemented
    - Variable weighting is done for Non-ignorable option

    Features that are not implemented yet:
    - No Normalization From D is done
    + No decomposition is done
    + No Thai/Lao orderding is done
    - No combining marks processing is done
    SQL ではこんな感じです。
    SELECT * FROM texts WHERE text_str = 'ア' COLLATE utf8_unicode_ci

Add a Fave for this Web page

What happens when I press Publish?
Your Fave for this Web page gets shared with the Faves community. You can access it at any time by selecting "My Faves" from the menu above.
Why do you ask for my email address?
We use your email address to create an account, so you can easily find your Fave again at a later time.
Rate It

Separate each email address with a comma.
WE DO NOT SPAM | Please read our privacy policy.

Related Content from Around Faves

mysql

VIEW ALL

php

VIEW ALL