Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint
Share this Page URL
Help

38. The System.Data.SqlTypes Namespace > SqlCompareOptions

Name

SqlCompareOptions

Synopsis

Specifies how SqlString instances are compared. You can use any bitwise combination of these values. BinarySort specifies that sorts should be based on the character’s numeric value, rather than its alphabetic value. IgnoreCase specifies that SqlString comparison won’t take capitalization into account. The other values apply primarily to extended character sets. For example, IgnoreKanaType specifies that SqlString comparisons must ignore the Kana type (the Kana type refers to Japanese hiragana and katakana characters, which represent phonetic sounds in the Japanese language). IgnoreNonSpace specifies that SqlString comparisons must ignore nonspace combining characters, such as diacritics. The Unicode Standard (see http://www.unicode.org) defines combining characters as characters that are combined with base characters to produce a new character. Finally, IgnoreWidth specifies that SqlString comparisons must ignore the character width (which can apply to languages such as Japanese where some characters can be written an full or half width).


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint