Professional Web Applications Themes

chinese character displaying as ???? in excel whileimporting data from sql-server 2000 - Coldfusion Database Access

Hi everyone, I am facing a problem while importing sql-server 2000 data in excelshhet ..There is some chinese character in database table. After importing data in excel chinese character looks like ????????.In sql-server this chinese character looks like square field. I am using UTF-8 . This is last hope. :sad; vijay k singh...

  1. #1

    Default chinese character displaying as ???? in excel whileimporting data from sql-server 2000

    Hi everyone,

    I am facing a problem while importing sql-server 2000 data in excelshhet
    ..There is some chinese character in database table.
    After importing data in excel chinese character looks like ????????.In
    sql-server this chinese character looks like square field.
    I am using UTF-8 .
    This is last hope.
    :sad;
    vijay k singh

    kanishkavijay Guest

  2. #2

    Default chinese character displaying as ???? in excel whileimporting data from sql-server 2000

    Hi everyone,

    I am facing a problem while importing sql-server 2000 data in excelshhet
    ..There is some chinese character in database table.
    After importing data in excel chinese character looks like ????????.In
    sql-server this chinese character looks like square field.
    I am using UTF-8 .
    This is last hope.
    :sad;
    vijay k singhText

    kanishkavijay Guest

  3. #3

    Default chinese character displaying as ???? in excel whileimporting data from sql-server 2000

    Hi everyone,

    I am facing a problem while importing sql-server 2000 data in excelshhet
    ..There is some chinese character in database table.
    After importing data in excel chinese character looks like ????????.In
    sql-server this chinese character looks like square field.
    I am using UTF-8 .
    This is last hope.
    :sad;
    vijay k singhText

    kanishkavijay Guest

  4. #4

    Default Re: chinese character displaying as ???? in excel whileimporting data from sql-server 2000

    Hi,

    Try using the <cfprocessingdirective> tag at the top of your page.. and set the "pageEncoding" attribute as "utf-8"
    Daverms Guest

  5. #5

    Default Re: chinese character displaying as ???? in excel while importingdata from sql-server 2000

    kanishkavijay wrote: 

    how is this data stored in the sql server table? how are you exporting it? what
    OS/office version are you importing to?

    PaulH Guest

Similar Threads

  1. Replies: 2
    Last Post: March 7th, 12:43 PM
  2. Displaying Chinese Character store in MySQL Database
    By Tiono in forum Macromedia ColdFusion
    Replies: 10
    Last Post: November 25th, 05:36 AM
  3. Chinese Character in SQL 2000
    By Franklin LO in forum Macromedia ColdFusion
    Replies: 1
    Last Post: May 29th, 04:23 PM
  4. Move data from Excel to SQL Server via ASP
    By midwesthills in forum ASP Database
    Replies: 6
    Last Post: August 3rd, 08:18 PM
  5. Retrieving data from sql server to excel in vb.net
    By Anne in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 14th, 03:14 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