Professional Web Applications Themes

utf8 & Jos? Feliciano - Coldfusion - Advanced Techniques

MULTILANGUAGE AND UTF8 Here it is... when I import "Jos? Feliciano" into my application... the MySQL db stores it as the string you see on the left. My db is defined as utf8 as well as the column in the table. All is ok in the db. Yet, when I query the db and output it to IE the following is displayed. --- Jos?? Feliciano. What is my problem... ??? I have looked at the following for direction and pretty much followed the example shown.... [url]http://www.sustainablegis.com/unicode/showMe.htm[/url] This is my HEADER info: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html lang="en-us" ...

  1. #1

    Default utf8 & Jos? Feliciano

    MULTILANGUAGE AND UTF8

    Here it is... when I import "Jos? Feliciano" into my application... the MySQL
    db stores it as the string you see on the left. My db is defined as utf8 as
    well as the column in the table. All is ok in the db. Yet, when I query the db
    and output it to IE the following is displayed. --- Jos?? Feliciano. What is my
    problem... ???

    I have looked at the following for direction and pretty much followed the
    example shown.... [url]http://www.sustainablegis.com/unicode/showMe.htm[/url]

    This is my HEADER info:

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html lang="en-us" dir="ltr">
    <HEAD>
    <title>blah</title>
    <meta http-equiv="Content-Type" content="text/html; cht=utf-8" />
    <meta http-equiv="Content-Language" content="en-us" />
    </HEAD>

    The following is contained in my application.cfm file:

    <cfprocessingDirective pageencoding="utf-8">
    <cfset setencoding("URL", "utf-8")>
    <cfset setencoding("Form", "utf-8")>
    <cfcontent type="text/html; cht=utf-8">

    Also, I have added the following to my queries...

    CONVERT(_latin1'#variables.myval#' USING utf8)

    I have done all that I know to do, yet I am not seeing the latin character...

    any input is welcomed.

    :frown;

    weblingual Guest

  2. #2

    Default Re: utf8 & Jos? Feliciano

    More information... I found the following information and am begining to thing
    that the data stored in the db is not the correct UTF-8 value. from the
    following I see the word arqueol&#243;gica... when the source is viewed it has
    a value of & #243; ... in my database the value does not contain a numeric
    sequence like I think it should.

    [url]http://www.uisic.uis-speleo.org/lexuni.html[/url]

    Is this the right direction for me to go?

    weblingual Guest

Similar Threads

  1. Problem with DBD::DB2 and UTF8.
    By Hemant Shah in forum PERL Modules
    Replies: 0
    Last Post: April 14th, 03:31 PM
  2. UTF8 encode
    By Pluda in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 24th, 06:15 PM
  3. problem with utf8
    By Hardkmel in forum PHP Development
    Replies: 0
    Last Post: December 3rd, 10:27 AM
  4. utf8 -> latin2
    By Bedo Sandor in forum Ruby
    Replies: 1
    Last Post: November 14th, 03:31 PM
  5. ISO-Latin and UTF8
    By Tulan W. Hu in forum PERL Miscellaneous
    Replies: 0
    Last Post: August 1st, 01:31 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