SQL Table Fields

[Katofiad]

Im trying write a script that will create a custom table for use in my persistent world. When the APS system creates the pwdata table it creates several fields with different names. Followed by these names are field types such as

• varchar(64)
  
• int(11)
  

What do these field type represent? Does the number in the paranthesis signify the number of characters that field can hold? Or is it the size in bytes?

[Papillon]

It depends on the data type. For MySQL varchars, it's the maxium size, for ints, it's the display length.

http://dev.mysql.com/doc/refman/5.0/en/data-types.html
_________________
Papillon

[Katofiad]

Thanks that clarified some things and gave me a great site to access for more SQL questions!