SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Fixed width datatype

    I am dynamically building a SKU and need it to be fixed-width.

    I thought "CHAR" was fixed-width, but I don't see where I can set the field-size in MySQL Workbench.


    TomTees

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    CHAR is fixed width

    what does "dynamically building" mean?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    CHAR is fixed width
    Okay. So, any idea why I cannot define the field width in MySQL Workbench?!


    what does "dynamically building" mean?
    Glad you asked!

    Here is another post that I made describing just that. *Your "expert" help is more than welcome.)



    TomTees

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by TomTees View Post
    Okay. So, any idea why I cannot define the field width in MySQL Workbench?!
    nope, i don't use that tool

    you might want to learn how to write the CREATE TABLE statement yourself, because then you can run it in any tool


    Quote Originally Posted by TomTees View Post
    Here is another post that I made describing just that. *Your "expert" help is more than welcome.)
    i saw that, but i'm not sure what you want help with
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    nope, i don't use that tool

    you might want to learn how to write the CREATE TABLE statement yourself, because then you can run it in any tool
    Oh, I usually write all my own code by hand, but since I'm using Workbench to help me visualize my ERD's, it would be nice if it did what you would expect it too.

    (Another lame CASE tool... *sigh*)



    i saw that, but i'm not sure what you want help with
    I see your response finally showed up after I made this last post here. (Some Sitepoint timing issues??)

    I'll respond over there.



    TomTees


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
  •