data type in column definition


Posted on 16th Feb 2014 07:03 pm by admin

Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in the functional spec are numbers.
In the column definition which one is efficient to define the data type as number or varchar?
Did you know?Explore Trending and Topic pages for more stories like this.
Code

1
2
3
4
5
6
7
8
9
No comments posted yet

Your Answer:

Login to answer
337 Like 20 Dislike
Previous forums Next forums
Other forums

Scrolling news bar and MySQL
I am not sure if this is the correct forum to post this on. If not, I apologize. I am still pretty

matching numbers inside ( )
I know I can match numbers by just [0-9]+, so I thought matching numbers inside ( ) would be somethi

Word Trimming
Hi Guys & Gals!!

Hope you are all ok....

I need some help with the following

PHP form authentication
Hi guys,

what am trying to achieve is this: Whenever a user tries to login to my website, an

Change Sort Order to Display Newest File First
Hi Guys,

I have a page that sorts the contents (PDFs) of a directory and displays them on the

max function question
Hi All
Ihave a table that holds shipment numbers and dates like this

select * from

Retrieving the 25 most recently added entries from all tables in a MySQL databas
Hello,

The code below works great. It creates a table that shows the 25 most recently added t

need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash