Re: MySQL text field lengths truncated

Bill Saffin wrote:

Here's the connection string (using TAdoConnection):
Provider=MSDASQL.1;Password=****;Persist Security Info=True;User
ID=****;Data Source=LeoKevinIssues


ok, so you're accessing to MySQL as local database using ODBC, right?
In this case:

- make sure you have the latest MyODBC version. I remember having
serious issues with dates with the last version I used, which was 3.51.
Can't tell if there was any problem with large strings, though. AFAIK
they are testing now version 5.05

- I see you are missing the OPTION parameter in the connection string.
Take a look at the following URLs and check if you need to set any of
the options. Either case, OPTION=3 is a good beginning and won't hurt.

http://www.connectionstrings.com/

http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration-connection-p
arameters.html

I've connected the field in question to a TDBMemo component. The
first error message I received said it was expecting a memo field but
it was actually a string.

a TDBMemo is well suited for text BLOBs and long alphanumeric fields.
That shouldn't be the issue. How are you connecting it?


--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Multipart connectionstring question
    ... I’ve got an asp.net site that contains an access database. ... running the same app both on my machine and my host without making changes. ... How could one even use a server.mappath with a database connection string? ...
    (microsoft.public.dotnet.general)
  • Installer - Custom Textboxes in UI problem
    ... void Install function. ... I've tested it by writing the string out to a text file ... put the connection string and I intend to test the db connectivity and write ... throw new InstallException("The database conection information is not ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Accessing mdb file via VB code
    ... None of the previous installs re-registers etc worked but I got it fixed ... If any of you know why my string would not work, ... You need a connection string like: ... Some people report it as happening to an entire new suite of boxes. ...
    (microsoft.public.vb.general.discussion)
  • Re: EXEC master..xp_cmdshell Prevention
    ... way to significantly reduce vulnerabilities around dynamic string execution. ... > I found that my web application did use a connection string in a file ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Re: Memo Field
    ... Use a query as the report's or form's RecordSource. ... Function would need to copy the string ... >>Dim strNew As String, strT as String ... >>> Is there a way to force a Return in a memo field? ...
    (microsoft.public.access.forms)