Fixed width datatype

Databases
1

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

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

i saw that, but i’m not sure what you want help with

3

CHAR is fixed width

what does “dynamically building” mean?

4

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.) :slight_smile:

TomTees

5

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