{"id":951,"date":"2015-05-26T15:15:33","date_gmt":"2015-05-26T06:15:33","guid":{"rendered":"http:\/\/www.climb.co.jp\/blog_dbmoto\/?p=951"},"modified":"2015-09-30T14:05:39","modified_gmt":"2015-09-30T05:05:39","slug":"%e9%96%a2%e6%95%b0%e3%82%92%e5%88%a9%e7%94%a8%e3%81%97%e3%81%9f%e5%85%83%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e5%a4%89%e6%8f%9b%e3%81%97%e3%81%a6%e3%81%ae%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/951","title":{"rendered":"[DBMoto]\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6642\u306e\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u65b9\u6cd5\uff08VB\/C#\u8a00\u8a9e\u9078\u629e\u3001\u95a2\u6570\u9069\u7528\u3001\u30e6\u30fc\u30b6\u95a2\u6570\u4f5c\u6210\u3001\u7f6e\u63db\u95a2\u6570\u3001\u4e00\u62ec\u8a2d\u5b9a\u624b\u9806\uff09"},"content":{"rendered":"

DBMoto\u3067\u306f\u901a\u5e38\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u52a0\u3048\u3001\u8907\u88fd\u5143\uff08\u30bd\u30fc\u30b9\uff09\u306e\u30c7\u30fc\u30bf\u3092\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u5909\u63db\u3057\u3001\u8907\u88fd\u5148\uff08\u30bf\u30fc\u30b2\u30c3\u30c8\uff09\u306b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u6a5f\u80fd\u304c\u5b9f\u88c5\u3055\u308c\u3066\u304a\u308a\u307e\u3059\u3002\"\"<\/a><\/p>\n

\u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n

\u30fbC#\u306e\u95a2\u6570
\n\u30fbVB\u306e\u95a2\u6570
\n\u30fb\u30e6\u30fc\u30b6\u95a2\u6570<\/p>\n

C#\u3001VB\u306e\u6a19\u6e96\u95a2\u6570\u3092\u4f7f\u7528\u3067\u304d\u308b\u4ed6\u3001DBMoto\u5185\u306b\u95a2\u6570\u3092\u30aa\u30ea\u30b8\u30ca\u30eb\u3067\u5b9a\u7fa9\u3057\u3001\u30e6\u30fc\u30b6\u95a2\u6570\u3068\u3057\u3066\u3054\u5229\u7528\u3044\u305f\u3060\u304f\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

\u4f8b\uff1a
\n\u30fbTrim\u95a2\u6570\uff1a\u524d\u5f8c\u306e\u7a7a\u767d\u3092\u9664\u53bb\u3059\u308b\u3000\u300c\u3000\u3000\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u3000\u3000\u300d\u21d2\u300c\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u300d
\n\u30fbUcase\u95a2\u6570\uff1a\u5c0f\u6587\u5b57\u3092\u5927\u6587\u5b57\u3078\u5909\u63db\u3059\u308b\u3000\u300cTable Data\u300d\u21d2\u300cTABLE DATA\u300d
\n\u30fb\u65e5\u4ed8\u578b\u3092\u6570\u5024\u306e\u307f\u306b\u5909\u63db\u3059\u308b\u72ec\u81ea\u306e\u30e6\u30fc\u30b6\u95a2\u6570\u3000\u300c2015\/05\/26\u300d\u21d2\u300c20150526\u300d<\/p>\n

\u25cf\u8a00\u8a9e\u306e\u9078\u629e<\/strong><\/h2>\n

C#\u3068VB\u3092DBMoto\u5185\u3067\u6df7\u5728\u3055\u305b\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u3069\u3061\u3089\u304b\u4e00\u65b9\u306b\u7d71\u4e00\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u624b\u9806\u3067C#\u3068VB\u306e\u5207\u308a\u66ff\u3048\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

1. \u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u753b\u9762\u3092\u958b\u304d\u307e\u3059\u3002
\n\"20150526-01\"<\/a><\/p>\n

2. \u30b9\u30af\u30ea\u30d7\u30c8\u8a00\u8a9e\u304b\u3089C#\u304bVB\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u306fC#\u3067\u3059\u3002
\n\"20150526-02\"<\/a><\/p>\n

\u25cf\u95a2\u6570\u9069\u7528\u624b\u9806<\/strong><\/h2>\n

1. \u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u5358\u4f4d\u3067\u30de\u30c3\u30d4\u30f3\u30b0\u304c\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u95a2\u6570\u3092\u9069\u7528\u3059\u308b\u30ab\u30e9\u30e0\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u95a2\u6570\u3078\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002
\n\"20150526-03\"<\/a>\"20150526-04\"<\/a>\"20150526-05\"<\/a><\/p>\n

2. \u30ab\u30e9\u30e0\u306b\u5bfe\u3057\u3066\u95a2\u6570\u3092\u9069\u7528\u3057\u307e\u3059\u3002\u4e0b\u8a18\u306e\u753b\u9762\u3067\u306fVB\u306eTrim\u95a2\u6570\u3092\u9069\u7528\u3057\u3066\u3044\u308b\u4f8b\u3067\u3059\u3002
\n\u203bVB\u306e\u5834\u5408\u306f[\u30ab\u30e9\u30e0\u540d].Trim()\u3001C#\u306e\u5834\u5408\u306f[\u30ab\u30e9\u30e0\u540d].ToString().Trim()
\n\"20150526-06\"<\/a><\/p>\n

3. \u95a2\u6570\u9069\u7528\u5f8c\u306f\u3002\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u77e2\u5370\u306e\u8272\u304c\u7dd1\u306b\u5909\u308f\u308a\u307e\u3059\u3002
\n\"20150526-07\"<\/a><\/p>\n

\u25cf\u30e6\u30fc\u30b6\u95a2\u6570\u4f5c\u6210\u30fb\u9069\u7528\u624b\u9806<\/strong><\/h2>\n

\u30e6\u30fc\u30b6\u95a2\u6570\u306f\u307e\u305a\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3066\u95a2\u6570\u3092\u5b9a\u7fa9\u3057\u3001\u6b21\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u3067\u95a2\u6570\u540d\u3092\u6307\u5b9a\u3059\u308b\u624b\u9806\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

1. \u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u5185\u306eGlobal\u30af\u30e9\u30b9\u5185\u306b\u95a2\u6570\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u4e0b\u8a18\u306e\u753b\u9762\u3067\u306fVB\u306b\u3066\u30e6\u30fc\u30b6\u95a2\u6570\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u307e\u3059\u3002
\n\"20150526-08\"<\/a><\/p>\n

2. \u30e6\u30fc\u30b6\u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u30671\u3067\u5b9a\u7fa9\u3057\u305f\u95a2\u6570\u540d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002
\n\"20150526-09\"<\/a><\/p>\n

\u25cf\u7279\u5b9a\u306e\u6587\u5b57\u306b\u5909\u63db\u3059\u308b\u305f\u3081\u306e\u7f6e\u63db\u95a2\u6570<\/strong><\/h2>\n

\u30bd\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u7279\u5b9a\u306e\u6587\u5b57\u306b\u5909\u63db\u3059\u308b\u969b\u306b\u306fReplace\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002
\n\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u30bd\u30fc\u30b9\u306e\u300c\u611b\u300d\u3068\u3044\u3046\u6587\u5b57\u3092\u300c\u3042\u3044\u300d\u3078\u5909\u63db\u3057\u3066\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3057\u307e\u3059\u3002VB\u3068C#\u3069\u3061\u3089\u3082\u540c\u3058\u3067\u3059\u3002<\/p>\n

\r\n[\u30ab\u30e9\u30e0\u540d].Replace("\u611b", "\u3042\u3044")\r\n<\/pre>\n
Replace\u95a2\u6570\u306fUnicode\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3082\u6307\u5b9a\u53ef\u80fd\u3067\u3059\u3002
\nVB\u306e\u5834\u5408\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3067\u304d\u307e\u3059\u3002<\/p>\n
\r\n' \u300cChrW(&Hxxxx)\u300d\u306exxxx\u306bUnicode\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\u611b\u304c\u300c611B\u300d\r\n[\u30ab\u30e9\u30e0\u540d].Replace(ChrW(&H611B), "\u3042\u3044")\r\n<\/pre>\n
C#\u306e\u5834\u5408\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3067\u304d\u307e\u3059\u3002<\/p>\n
\r\n\/\/ \u300c\\uxxxx\u300d\u306exxxx\u306bUnicode\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002\u611b\u304c\u300c611B\u300d\r\n[\u30ab\u30e9\u30e0\u540d].Replace("\\u611B", "\u3042\u3044");\r\n<\/pre>\n
\u25cf\u95a2\u6570\u306e\u4e00\u62ec\u8a2d\u5b9a<\/strong><\/h2>\n
\u95a2\u6570\u3092\u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u3067\u30ab\u30e9\u30e0\u5358\u4f4d\u3067\uff11\u3064\u305a\u3064\u8a2d\u5b9a\u3059\u308b\u306e\u306f\u3069\u3046\u3057\u3066\u3082\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u3002\u3053\u306e\u6642\u9593\u3092\u77ed\u7e2e\u3057\u3001\u4e00\u62ec\u3067\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n
1. \u95a2\u6570\u306e\u4e00\u62ec\u8a2d\u5b9a\u306f\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u5185\u306eMappingRule\u30af\u30e9\u30b9\u306b\u3066\u8a18\u8ff0\u3057\u307e\u3059\u3002
\n\u4e0b\u8a18\u306e\u4f8b\u3067\u306fVB\u3067VARCHAR\u306e\u30ab\u30e9\u30e0\u306b\u5bfe\u3057\u3001Replace\u95a2\u6570\u306b\u3066\u300c\u611b\u300d\u3092\u300c\u3042\u3044\u300d\u3078\u5909\u63db\u3059\u308b\u8a2d\u5b9a\u3092\u4e00\u62ec\u3067\u884c\u3046\u305f\u3081\u306e\u5185\u5bb9\u3067\u3059\u3002
\n\"20150526-10\"<\/a><\/p>\n
\r\nImports System\r\nImports System.Data\r\nImports Microsoft.VisualBasic\r\nImports DBMotoPublic\r\nImports DBMotoScript\r\n\r\nNamespace DBRS\r\n    Public Class GlobalScript : Inherits IGlobalScript\r\n\r\n    End Class\r\n\r\n    Public Class MappingRule : Inherits IMappingRule\r\n        <MappingRuleAttribute("Replace(VARCHAR)", "\u300c\u611b\u300d\u3092\u300c\u3042\u3044\u300d\u3078\u5909\u63db")> _\r\n        Public Function Function1 (ByVal bIsForth As Boolean, ByVal sSourceName As String, ByVal iSourceOrdinal As Integer, ByVal sSourceType As String, ByVal sTargetName As String, ByVal iTargetOrdinal As Integer, ByVal     sTargetType As String, ByRef sExpression As System.Text.StringBuilder) As Boolean\r\n\r\n            If sSourceName = sTargetName Then\r\n                If sSourceType = "VARCHAR" Then\r\n                    sExpression.Append("[" + sTargetName + "].Replace(ChrW(&H611B), ""\u3042\u3044""")\r\n                End If\r\n                Return True\r\n            Else\r\n                Return False\r\n            End if \r\n\r\n        End Function\r\n    End Class\r\n\r\n    Public Class GlobalEvents : Inherits IGlobalEvents\r\n\r\n    End Class\r\nEnd Namespace\r\n<\/pre>\n
2. \u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u306b\u3066\u300c\u30ab\u30b9\u30bf\u30e0\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u304b\u3089\u8a72\u5f53\u306e\u3082\u306e\u3092\u9078\u629e\u3057\u307e\u3059\u3002
\n\"20150526-11\"<\/a><\/p>\n
3. \u4e00\u62ec\u3067\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002
\n\"20150526-12\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
DBMoto\u3067\u306f\u901a\u5e38\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u52a0\u3048\u3001\u8907\u88fd\u5143\uff08\u30bd\u30fc\u30b9\uff09\u306e\u30c7\u30fc\u30bf\u3092\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u5909\u63db\u3057\u3001\u8907\u88fd\u5148\uff08\u30bf\u30fc\u30b2\u30c3\u30c8\uff09\u306b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u6a5f\u80fd\u304c\u5b9f\u88c5\u3055\u308c\u3066\u304a\u308a\u307e\u3059\u3002 \u4f7f\u7528\u3067\u304d\u308b\u95a2\u6570\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002 \u30fbC#\u306e\u95a2\u6570 \u30fbVB … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[162,64,65],"class_list":["post-951","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-c","tag-64","tag-vb"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=951"}],"version-history":[{"count":7,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/951\/revisions"}],"predecessor-version":[{"id":2599,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/951\/revisions\/2599"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}