Professional Web Applications Themes

inserting Japanese characters to SQL Server via CFMX - Coldfusion Database Access

What is necessary in the setup to save non-Latin characters to SQL Server via CFMX form? The ColdFusion data source has the Unicode option enabled (Enable Unicode for data sources configured for non-Latin characters). The target field in the database is an nvarchar. What else is necessary to properly insert and then later display the non-Latin characters? On Microsoft's site they describe the need to convert to and from UCS-2 when accessing SQL Server via ASP. Is this type of conversion relevant to CFMX?...

  1. #1

    Default inserting Japanese characters to SQL Server via CFMX

    What is necessary in the setup to save non-Latin characters to SQL Server via
    CFMX form? The ColdFusion data source has the Unicode option enabled (Enable
    Unicode for data sources configured for non-Latin characters). The target field
    in the database is an nvarchar. What else is necessary to properly insert and
    then later display the non-Latin characters?

    On Microsoft's site they describe the need to convert to and from UCS-2 when
    accessing SQL Server via ASP. Is this type of conversion relevant to CFMX?

    jegrubbs Guest

  2. #2

    Default Re: inserting Japanese characters to SQL Server via CFMX

    jegrubbs wrote:
    > What is necessary in the setup to save non-Latin characters to SQL Server via
    > CFMX form? The ColdFusion data source has the Unicode option enabled (Enable
    > Unicode for data sources configured for non-Latin characters). The target field
    > in the database is an nvarchar. What else is necessary to properly insert and
    > then later display the non-Latin characters?
    - define db columns as "N" types
    - ensure cf pages are utf-8 encoding:
    --tag the files w/a BOM
    --use
    <cfprocessingDirective pageencoding="utf-8">
    on each page
    --use
    <cfset setEncoding("form","utf-8")>
    <cfcontent type="text/html; cht=utf-8">
    in application.cfm or .cfc
    - when doing INSERT/UPDATE make sure to use either unicode hinting (N'text') or
    cfqueryparam (making sure to turn on the unicode option for that DSN in
    cfadmin). cfqueryparam is the best choice.

    also see: [url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url]
    > On Microsoft's site they describe the need to convert to and from UCS-2 when
    > accessing SQL Server via ASP. Is this type of conversion relevant to CFMX?
    nope the JDBC driver will handle that gruff. make sure you use the JDBC driver
    (name as ms sql server in cfadmin) and NOT the odbc bridge thnig.

    PaulH *ACE* Guest

Similar Threads

  1. Japanese characters.
    By palaksha@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 3
    Last Post: June 30th, 12:32 PM
  2. Japanese characters
    By koeniga in forum Coldfusion - Getting Started
    Replies: 7
    Last Post: May 4th, 04:58 PM
  3. Japanese Characters?
    By Philipp Lenssen in forum Macromedia Flash
    Replies: 1
    Last Post: September 19th, 10:08 AM
  4. Replies: 1
    Last Post: August 12th, 03:28 PM
  5. Viewing PSD's with Japanese characters
    By Hugo Reyes in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 0
    Last Post: July 7th, 11:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139