Professional Web Applications Themes

problem with тащи: how can I do? - MySQL

Hallo, I have a problem with атщи letter. which language I have to choice? it is einought to choice right language? Thank you in advance, Mario....

  1. #1

    Default problem with тащи: how can I do?

    Hallo,
    I have a problem with атщи letter.
    which language I have to choice?
    it is einought to choice right language?
    Thank you in advance,
    Mario.
    _mario.lat Guest

  2. #2

    Default Re: problem with тащи: how can I do?

    On Thu, 12 Apr 2007 15:53:09 +0200, _mario.lat wrote: 

    It is enough to choose an appropriate character set, sort order, and
    take some care to use compatible tools to load and extract data. If your
    database is utf8, your input must send utf8 data, and your export must
    account for utf8 set.

    --
    "25 grams of wafers and 20 ml of wine undergo transubstantiation and
    become the flesh and blood of our Lord. How many Joules of heat are
    released by the transformation?" --Theological Physics exam, 1997
    Peter Guest

  3. #3

    Default Re: problem with тащи: how can I do?

    Actually, there is a tiny bit more to it than that.

    Trying to write compatible code, I configured the database to use utf-8
    internally on both the server and the client ([mysqld] and [mysql]
    sections of the config file). However, the [mysql] section is NOT used
    for defaults in client settings, it is only used for the command-line
    client.
    This means that, if you configure your entire database to use utf-8, the
    connection will use latin-1 en RE-ENCODE to utf-8! On the positive side,
    it will also double-decode the data, SO YOU WON'T NOTICE. Until you
    start filling the database with other clients (front-ends), that is.

    Now here's the caveat:
    In MySQL 5, all connections default to latin-1, except for the
    command-line client, which is configurable. You must specifically issue
    a "SET NAMES utf-8" statement to really get it to use utf-8. Off course,
    the SET NAMES command was introduced in MySQL 4, so you will have to
    check the server version before that.
    I don't even want to know how on earth you could ever issue a "S.E.T.
    ..N.A.M.E.S. .u.c.s.2." command and make it work.

    In MySQL 4.x, there is no automatic re-encoding yet. So these versions
    work as expected without the need to send an incompatible command.

    To check if the data in the database is re-encoded, use the mysqldump
    utility to dump a table that has a record with a special character. Use
    the command-line options to make it generate a utf-8 encoded file. Then,
    look at the file. If you see the well known A~ sequences, the database
    content is re-encoded.

    Best regards

    Peter H. Coffin wrote: 
    >
    > It is enough to choose an appropriate character set, sort order, and
    > take some care to use compatible tools to load and extract data. If your
    > database is utf8, your input must send utf8 data, and your export must
    > account for utf8 set.
    >[/ref]

    --
    Willem Bogaerts

    Application smith
    Kratz B.V.
    http://www.kratz.nl/
    Willem Guest

Similar Threads

  1. contribute problem - access denied file may not existpermission problem
    By Al1973 in forum Macromedia Contribute Connection Administrtion
    Replies: 6
    Last Post: September 17th, 04:16 PM
  2. Replies: 2
    Last Post: September 30th, 12:13 PM
  3. Replies: 0
    Last Post: August 23rd, 11:56 AM
  4. Replies: 2
    Last Post: July 17th, 07:27 AM

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