What datatype in MySQL would be best to use for data that was in Memo on Microsoft Access?
Microsoft Access memo datatype to MySQL Datatype
7.2k views Asked by suryll At
2
There are 2 answers
0
Doozer Blake
On
I believe that would be the TEXT type in MySQL you are looking for.
The equivalent on Microsoft SQL server would now be NVARCHAR(MAX) on newer versions, and NTEXT on older versions.
Related Questions in MYSQL
- How to Retrieve Data from an MySQL Database and Display it in a GUI?
- How to change woocomerce or full wordpress currency with value from USD to AUD
- window.location.href redirects but is causing problems on the webpage
- Error: local variable 'bramka' referenced before assignment
- Products aren't displayed after fetching data from mysql db (node.js & express)
- status table for all entries (even in different dates) in database changing value when all checkboxes are checked
- Can't Fix Mariadb & Mysql ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2) On MacOs
- Express Mysql getting max ID from table not working cought in a promise
- failed to upload a table from sql file
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- How to display the column names which have only unique non-null values in MySQL table?
- mysql query takes too long because of wrong indexes usage
- Multitable joining in Sql
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in MS-ACCESS
- Ctrl+' for copying from previous record in MS Access not working bilingual in Access 2016
- Updating Access Database using C# and stored procedure does not work
- SQL Left Join not including desired rows
- Published MAUI app doesn't work with access database
- Microsoft access sql query to update last record
- Syntax error in FROM clause C# and MSAccess
- sum function in a report
- Excel column datatype issues using MSADO and Access 2016 Engine driver
- Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API
- ms-access email electronic signiture
- "Make Trusted Document" warning doesn't trigger until exit, causing "Can't exit now" error
- How to compile java gdal PGEO on apple silicon MacOS to read mdb file?
- Access won't open past the splash screen
- Access, Relationship. Too complicated Syntax?
- Table Update from a form using VBA
Related Questions in SQLDATATYPES
- Converting column values in postgresql from text to smallint throws error
- Datatype creation in SQL for Oracle
- How can I convert the data types of a DataFrame to the SQL data types?
- Making column that has interval data type from a column of string in BIG QUERY
- Convert excel date to timestamp in PostgreSQL
- Data type recommendes to save datetime in oracle and java
- Safely convert REAL to INT when values exceed INT range?
- How to convert datatype from nvarchar to numeric
- Which data type is the result of division？
- PyMySQL Data types
- Abinitio explicit fixed point
- Is it OK to use the DEC data type in PostgreSQL
- how the dbeaver get the mysql column real type, where is the source code
- Conversion failed when converting the varchar to data type int when inserting multiple items
- Unable to import data as numeric from Excel file
Related Questions in MEMO
- Multiple renders of TradingView Widget
- React Memoized component always contains the same values on the next and prev props
- Just need a small solution for not rendering a component in react app
- Why memoized items are not persisted in parent components?
- change TextInput value other component will re render again although I wrap it in memo() and useCallback()
- Should useCallback() be used on a function passed as a prop to a child component even if said component is wrapped in a memo()?
- How to hook the appearence of ScrollBar in Memo?
- Why React.memo fails to memoize this component?
- React memo previous props and new props are same in child of context consumer even when the context value has changed
- How do I add placeholder text for a Memo in a Python FMX GUI App?
- Why do <div> tags appear in FMX Memo Component when being populated from Microsoft Access Long Text Field?
- Will the component be re-rendered every time I enter the page even though the data hasn't changed?
- React memoize inside a map function
- Optimize component in React js, so that items are not rendered every time
- Substituting a reserved value dynamically doesn't work
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
TEXT would be a good match.
Text is a blob field that is meant to store strings.
blob is the same for binary data.
See: http://dev.mysql.com/doc/refman/5.0/en/blob.html
Make sure you use a text/blob variant that is large enough to hold the data that is currently in your
memofield.When in doubt
longtextwill hold up to 4GB.