11-06-2007
RE: Mysql CHAR vs VARCHAR
Actually a VARCHAR(10) will only allow up to 10 characters and no more.
The main difference between CHAR and VARCHAR is how data is stored in the column. The length of a CHAR column is fixed and when CHAR values are stored, they are right-padded with spaces to the specified length. In contrast to CHAR, VARCHAR values are stored using only as many characters as are needed.
Please see the MySQL docs for more details:
MySQL AB :: MySQL 5.0 Reference Manual :: 10.4.1 The CHAR and VARCHAR Types
Cheers!
Nate
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
How to replace any character in a file with a newline character using sed ..
Ex:
To replace ',' with newline
Input:
abcd,efgh,ijkl,mnop
Output:
abcd
efgh
ijkl
mnop
Thnx in advance.
Regards,
Sasidhar (5 Replies)
Discussion started by: mightysam
5 Replies
2. Programming
Hello,
I'm trying to write a method which will return the extension of a file given the file's name, e.g. test.txt should return txt. I'm using C so am limited to char pointers and arrays. Here is the code as I have it:
char* getext(char *file)
{
char *extension;
int i, j;... (5 Replies)
Discussion started by: pallak7
5 Replies
3. UNIX for Advanced & Expert Users
Hi ,
I need to sort a file based on multiple columns All the columns are of varchar type
can any one give me the command to sort for varchar columns?
Thanks (3 Replies)
Discussion started by: laxmi131
3 Replies
4. Programming
hello everybody!
i have aproblem! i dont know how to concatenate const char* with char
const char *buffer;
char *b;
sprintf(b,"result.txt");
strcat(buffer,b);
thanx in advance (4 Replies)
Discussion started by: nicos
4 Replies
5. Programming
Compiling xpp (The X Printing Panel) on SL6 (RHEL6 essentially):
xpp.cxx: In constructor ‘printFiles::printFiles(int, char**, int&)’:
xpp.cxx:200: error: invalid conversion from ‘const char*’ to ‘char*’
The same error with all c++ constructors - gcc 4.4.4.
If anyone can throw any light on... (8 Replies)
Discussion started by: GSO
8 Replies
6. UNIX and Linux Applications
After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the:
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies
7. Programming
Pointers are seeming to get the best of me and I get that error in my program.
Here is the code
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#define REPORTHEADING1 " Employee Pay Hours Gross Tax Net\n"
#define REPORTHEADING2 " Name ... (1 Reply)
Discussion started by: Plum
1 Replies
8. UNIX for Beginners Questions & Answers
hallo,
yould you guys help me?
im using bash script
i have file getnumber.csv
cat getnumber.csv
234198
654639
eht4v4
453nbddme
43
455fr
i try this
cat getnumber.csv | sed 's/*//g'
but the result is :
234198 (5 Replies)
Discussion started by: kivale
5 Replies
LEARN ABOUT DEBIAN
tangram::type::scalar
Tangram::Type::Scalar(3pm) User Contributed Perl Documentation Tangram::Type::Scalar(3pm)
NAME
Tangram::Type::Scalar - map scalar fields
SYNOPSIS
use Tangram;
Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string => [ qw( name firstName gender ) ],
int => [ qw( age ) ],
real => [ qw( height weight ) ],
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
string =>
{
name => { sql => 'VARCHAR(100)' },
1stname => {
col => 'firstName',
sql => 'VARCHAR(100) NULL' },
gender => undef()
},
DESCRIPTION
Classes Tangram::Type::String, ::Int and ::Real and ::Ref are responsible for mapping the various subtypes of scalars. The first three map-
pings are documented here since they differ very little. See Tangram::Type::Ref::FromMany for information on mapping references.
Tangram::Type::String uses DBI's quote() method to quote strings if that method is available, thus making it possible to store binary
objects or multiline text in databases that support it (thanks to Marian Kelc <marian.kelc@ruhr-uni-bochum.de> for suggesting this improve-
ment).
The three predefined typetags "string", "int" and "real" are for the corresponding Perl scalar subtypes.
Each scalar field is stored in a single column of the table associated to the class.
The persistent fields may be specified either as a hash or as an array of field names.
In the hash form, each entry consists in a field name and an associated option hash. The option hash may contain the following fields:
* col
* sql
* automatic
"col" sets the name of the column used to store the field's value. This field is optional, it defaults to the persistent field name. Over-
ride if the field name is not an acceptable SQL column name.
"sql" sets the SQL type of the column. Used by Schema::deploy() when initializing a database. Defaults to 'VARCHAR(255) NULL' for strings,
'INT NULL' for ints and 'REAL NULL' for reals.
"automatic", if set to true, tells Tangram not to save the field to storage. This is useful for auto-increment or timestamp columns.
The persistent fields may also be specified as an array of strings, in which case the defaults are used.
perl v5.8.8 2006-03-29 Tangram::Type::Scalar(3pm)