Re: Handling Memo Fields from MS-Access?/\t\n

2002-04-15 Thread Tim Johnson
Forgive me, I should have searched the archives first. Let me rephrase from what I have seen there: Do I understand that I should have my export routine Subsitute '\n' for newline ? Substitute '\t' for TAB? Thanks Again -tim- * Tim Johnson <[EMAIL PROTECTED]> [020415 15:13]: > Hello A

RE: Handling Memo Fields from MS-Access?

2002-04-15 Thread Gurhan Ozen
From: Tim Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 7:09 PM To: [EMAIL PROTECTED] Subject: Handling Memo Fields from MS-Access? Hello All: I am using mysql 3.23 on Linux. I have a project in what I will need to do the following: First: export a

Handling Memo Fields from MS-Access?

2002-04-15 Thread Tim Johnson
Hello All: I am using mysql 3.23 on Linux. I have a project in what I will need to do the following: First: export a MS-Access database to a set of delimited text files, one for each table. Secondly: Load each of those text files into a MySql Table. Since I am new to MyS

Re: "Memo" Fields

2001-04-11 Thread Marty Landman
At Wednesday 4/11/01 10:32 AM, Frank Schmuck, CFO wrote: >I have a database of e-mail messages, the body of which is currently a >"memo" field. I want to convert these to MySQL (or to create a new one in >MySQL). Frank, for potentially large variable length strings Mysql provides the 'blob' dat

RE: "Memo" Fields

2001-04-11 Thread Robert Barrington
Message- From: Frank Schmuck, CFO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 7:32 AM To: '[EMAIL PROTECTED]' Subject: "Memo" Fields I have a database of e-mail messages, the body of which is currently a "memo" field. I want to convert these to My

"Memo" Fields

2001-04-11 Thread Frank Schmuck, CFO
I have a database of e-mail messages, the body of which is currently a "memo" field. I want to convert these to MySQL (or to create a new one in MySQL). Is the equivalent of a memo field in MySQL a varchar of x length? If so how long do you make the field so that it does not truncate the end o

Memo fields

2001-02-14 Thread MANGERA, Faizal
Hi everyone, Got a problem, hopefully somebody can help. I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have a number of fields that are of the type "blob" which match up to the field type "memo" in Lotus Approach. If I insert data