Professional Web Applications Themes

detecting character set of a column? - MySQL

I was reading [url]http://dev.mysql.com/tech-resources/articles/4.1/unicode.html[/url] and was sorta wondering... One of the sample queries they give is as follows: ALTER TABLE myTable MODIFY myColumn VARCHAR(255) CHARACTER SET utf8; How would one go about detecting the existing character set of a column?...

  1. #1

    Default detecting character set of a column?

    I was reading
    [url]http://dev.mysql.com/tech-resources/articles/4.1/unicode.html[/url] and was
    sorta wondering...

    One of the sample queries they give is as follows:

    ALTER TABLE myTable MODIFY myColumn VARCHAR(255) CHARACTER SET utf8;

    How would one go about detecting the existing character set of a column?

    yawnmoth Guest

  2. #2

    Default Re: detecting character set of a column?

    >I was reading
    >[url]http://dev.mysql.com/tech-resources/articles/4.1/unicode.html[/url] and was
    >sorta wondering...
    >
    >One of the sample queries they give is as follows:
    >
    >ALTER TABLE myTable MODIFY myColumn VARCHAR(255) CHARACTER SET utf8;
    >
    >How would one go about detecting the existing character set of a column?
    SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
    TABLE_SCHEMA='$database' AND TABLE_NAME='myTable' and COLUMN_NAME='myColumn';

    Requires MySQL 5.0 or greater, I think.

    I think:
    SHOW FULL COLUMNS FROM myTABLE;

    also works, but I'm not sure what version that requires. Also, you
    have to fish through the output; you don't get a WHERE clause.

    Gordon L. Burditt
    Gordon Burditt Guest

Similar Threads

  1. Converting a 3 column pdf address list to a one column MS word doc
    By Jay_Jump@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: February 9th, 06:46 PM
  2. Column chart need column to exceed axis maximum value
    By zanedev in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: May 8th, 04:26 PM
  3. InDesign ME Character Problem! Character-Change by Printing or saving *.PS!
    By gree@adobeforums.com in forum Adobe Indesign Windows
    Replies: 48
    Last Post: May 25th, 02:07 PM
  4. Replies: 0
    Last Post: September 15th, 04:33 PM
  5. Replies: 0
    Last Post: July 7th, 08:32 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