- Home /home on the range…
EasyTable Pro! product info & how-to's
- Get EasyTable Pro!
- Getting Started
- Manager Features
- Search Options
- Field Types & Tokens
- Displaying your Table
- Detail View
- Advanced Display Options
- Advanced Settings
- Automatic Imports using CRON
- EasyGitHub Include
- EasyTable Pro! product info & how-to's
Downloads get your files here...
- EasyTable Pro! Login to see your downloads
- EasyNAB for AkSubs Login to see your downloads
- EasyNAB for JDonation Login to see your downloads
- EasyTable for J! free... as in beer.
- EasyGitHub Include ...the geeks content plugin...
- EasyStaging ...your website staging helper...
- EasyDownloads ...your secure download manager...
- CommWeb/MIGS for VM2 Login to see your downloads
- Register for Forums
- Category: 1.0
- Published on Saturday, 17 July 2010 15:41
- Written by Craig Phillips
- Hits: 6704
EasyTable Pro supports all the standard types found in EasyTable for J! and two additional fields types to help provide better display, sorting and storage features.
It also support field options that affect the formatting of each field, you can read more about that in EasyTable Pro - Field Display Options. This article is about the way each type is stored in MySQL and some things you will want to watch out for. When you change the field type in an EasyTable you've created the underlying MySQL column type is changed as well, when this happens MySQL tries to convert any data in the columns to fit the new type - sometimes this can cause issues. The two most common issues are data truncation or data in an invalid format for the new type.
The good thing is that you can re-import the data from your CSV or TAB file quickly and easily if you experience a problem.
Data truncation typically occurs when the data stored in a Text format field is too large for the intended type you have selected. As a Text field can hold literally entire books worth of text converting to any other type has the potential to truncate the date. If you are not using the text field to contain lots of text you will probably be OK, if however you change a Text field that contains more than 255 chars to an Image, Link or Email Address field type - characters after the first 255 will be truncated. ie. cut off.
|Original Text Field Contents||Size||After Conversion to an Image/Link/Email Address||Size|
|A large piece of text may contain many hundreds of characters, as is the case with this paragraph. In this table the left column shows the original data followed by a size column that denotes the number of chars stored. The third column shows the result after conversion to one of the smaller text formats followed by the resulting size. The examples include this row which is larger that the 255 character limit of the the other text types, the next row which is just less than that limit and a final row that contains a typical type of text content that is well below the 255 character limit.||594||A large piece of text may contain many hundreds of characters, as is the case with this paragraph. In this table the left column shows the original data followed by a size column that denotes the number of chars stored. The third column shows the result a||255|
|Now is the winter of our discontent. Whether tis nobler in the mind to suffer the slings and arrows of outrageous fortune, Or to take arms against <a href="http://www.google.com.au/search?q=iphone+4+death+grip">a death grip</a>, And by opposing end it?||252||Now is the winter of our discontent. Whether tis nobler in the mind to suffer the slings and arrows of outrageous fortune, Or to take arms against <a href="http://www.google.com.au/search?q=iphone+4+death+grip">a death grip</a>, And by opposing end it?||252|
If you are converting a Text, Image, Link or Email Address field type to a Number or Date and the original contents of the field are not in a suitable format the conversion will fail, resulting in the loss of data.
For conversion to a Number we recommend you read the MySQL discussion of Numeric Types if you experience conversion problems.
For conversion to Date we similarly recommend you read the MySQL discussion of Date Types.
|Original Text Field Contents||New Type||After Conversion|
|A piece of text may contain a date, but it may not convert if MySQL doesn't understand it.||DATE||
*(Yes - it's empty, MySQL couldn't find a date value it recognised.)
The following table show's how each of the EasyTable Pro field types maps to MySQL Types
|EasyTable Type||MySQL type||Typical Data||Notes|
|Text||TEXT||Now is the winter of our discontent. Whether tis nobler in the mind to suffer the slings and arrows of outrageous fortune, Or to take arms against <a href="http://www.google.com.au/search?q=iphone+4+death+grip">a death grip</a>, And by opposing end it?||The largest storage type TEXT fields can contain very large amounts of data. Converting to TEXT is generally issue free. Converting from TEXT to any other format runs the risk of data being truncated or lost completely if it's not in a format that useable by the new type.|
|Image, Link or Email Address||VARCHAR(256)||george_washington.jpg|
|Number||FLOAT||1,234,456.7890||A FLOAT type allows for real world decimal style numbers with varying precision. Most number formats in CSV & TAB files can be imported without issue.|
Date fields in your import file should be in a format MySQL recognises such as YYYY-MM-DD.
MySQL retrieves and displays
EasyTable Pro! Subscriptions
EasyTable Pro! Subscriptions are available for 1 or 3 months.
Popular Related Articles
EasyTable Pro!… Read More +
With EasyTable Pro's field options you can combine several fields to produce a custom URL for each record. There are lots… Read More +
Sorting CSS Classes
When table sorting is enable clicking on the column heading will sort the records on the current page… Read More +
EasyTable for J 1.0+ and EasyTable Pro! imports data in a CSV file format. (EasyTable Pro! also supports the TSV… Read More +
Simply put, EasyTable is a… Read More +