Professional Web Applications Themes

Unicode Text Issues with ASP/ADO - ASP Database

So I've got a nasty little problem with ADO in the old ASP platform. We are extending an existing web site to include a Japanese Language version. We have built a tool in C# where users can write Japanese Strings into a SQL Server Table, The table columns are Unicode and we are using the N prefix on our insert and update statements. All of the Japanese versions of the HTML the pages emit have been set to the UTF-8 cht, and from what I can tell this is the cht that tools like Excel use to deal with most ...

  1. #1

    Default Unicode Text Issues with ASP/ADO

    So I've got a nasty little problem with ADO in the old ASP platform. We are extending an existing web site to include a Japanese Language version. We have built a tool in C# where users can write Japanese Strings into a SQL Server Table, The table columns are Unicode and we are using the N prefix on our insert and update statements.

    All of the Japanese versions of the HTML the pages emit have been set to the UTF-8 cht, and from what I can tell this is the cht that tools like Excel use to deal with most other languages. Google seems to use this cht for all languages. A lot of the data has gotten into the system via cut-n-paste from Excel files sent to us from translators in Japan. We have pasted data into our ASP.Net forms and into Enterprise Manager, We have even used DTS to load some of the data

    If we read the data back from SQL through ADO.Net and inject it into the page it displays in the proper cht just fine. But when we read the data with ADO and display it in the older pages we get garbage. I have tried many things to get around this to no avail

    Any ideas and suggestions would be greatly appreciated

    Thanks

    - Ole


    Oleg Guest

  2. #2

    Default Re: Unicode Text Issues with ASP/ADO

    Try adding

    session.codepage=65001

    to each asp page.

    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    [url]www.ielearning.com[/url]


    "Oleg" <anonymousdiscussions.microsoft.com> wrote in message
    news:4F55DAA5-AC52-49BB-9A27-2DBD3BB46071microsoft.com...
    > So I've got a nasty little problem with ADO in the old ASP platform. We
    are extending an existing web site to include a Japanese Language version.
    We have built a tool in C# where users can write Japanese Strings into a SQL
    Server Table, The table columns are Unicode and we are using the N prefix on
    our insert and update statements.
    >
    > All of the Japanese versions of the HTML the pages emit have been set to
    the UTF-8 cht, and from what I can tell this is the cht that tools
    like Excel use to deal with most other languages. Google seems to use this
    cht for all languages. A lot of the data has gotten into the system via
    cut-n-paste from Excel files sent to us from translators in Japan. We have
    pasted data into our ASP.Net forms and into Enterprise Manager, We have even
    used DTS to load some of the data.
    >
    > If we read the data back from SQL through ADO.Net and inject it into the
    page it displays in the proper cht just fine. But when we read the data
    with ADO and display it in the older pages we get garbage. I have tried
    many things to get around this to no avail.
    >
    > Any ideas and suggestions would be greatly appreciated!
    >
    > Thanks,
    >
    > - Oleg
    >
    >

    Mark Schupp Guest

  3. #3

    Default RE: Unicode Text Issues with ASP/ADO

    I found a solution

    The ASP page you have handles text in some non-Unicode form. Set the CODEPAGE property of the page to UTF-8 ("<%CODEPAGE=65001...>"), or do it at the Session level. Make sure the cht in the HTTP header is set to UTF-8 too.
    Oleg Guest

Similar Threads

  1. Add Unicode Text with PDETextAdd and PDEFontCreateFromSysFont
    By Doron_Tal@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 2
    Last Post: January 2nd, 01:47 PM
  2. Unicode and newline characters in XML text sond via Web Service
    By Krzysztof Fink-Finowicki via .NET 247 in forum ASP.NET Web Services
    Replies: 6
    Last Post: January 23rd, 05:29 PM
  3. DataGrid exception on U+200D in text w/ Arial Unicode MS font
    By Pete Dembrowski in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: June 17th, 06:36 AM
  4. Unicode text and Photoshop 7 -- CS ????
    By Todd_DeBonis@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 2
    Last Post: April 29th, 07:50 PM
  5. Cocoa: simple HTML text to Unicode
    By Simon Slavin in forum Mac Programming
    Replies: 3
    Last Post: September 8th, 04:30 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