utf8 & Jos? Feliciano

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  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; charset=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; charset=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. Similar Questions and Discussions

    1. Problem with DBD::DB2 and UTF8.
      Folks, Here is my setup: DB2 V8.2 ESE running on Linux with utf-8 code set. Database territory = us...
    2. UTF8 encode
      Hello there, I need help! :-) How do we pass variables to php in UTF 8 encode? I have one php, whicth sends emails, and the subject of them...
    3. problem with utf8
      hi people, i have a script : <? $num=0; $backendURL = "http://rezo.net/backend/afp"; $limit = 1; // nombre maxi de news à afficher. $file...
    4. utf8 -> latin2
      Hi, How can I convert utf-8 encoded strings to latin-2? I have tried it using libuconv with little success: require 'uconv' class String...
    5. ISO-Latin and UTF8
      "Philip M. Gollucci" <pgollucci@ejpress.com> wrote in... ISO-LATIN. You might want to try the newer Encode in Perl 5.8.1. my $utf8_line =...
  3. #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

Posting Permissions

  • You may not post new threads
  • You may 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