Re: MySQL text field lengths truncated

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

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.

"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:453c97c3$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Bill Saffin wrote:

I'm new to MySQL development. I'm using Delphi 7, ADO components,
connecting to a remote MySQL server 4.1.10.

I've got a text field in a table in the database. When I use
varchar(255) for the type, I get 255 characters in the field. When I
try other text types (Medium Text, Long Text) with larger numbers
specified (I've tried 512, 1024, 4096), I can't get more than 162
characters. I checked this by adding fields to the query (edit the
field list).

I've searched for this type of error, but can't find a solution. I
can't use a longer varchar type because the web hosting company isn't
ready to move to MySQL 5.

Anybody solve this type of problem?

How are you accessing the MySQL server? What does your connection
string look like? What kind of field are you trying to use (in your
app, not in the MySQL server)?

--
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

  • Re: ADO connections question
    ... Function CreateADOObjects(ConnectionString as string) ... you'll see this error if the connection has not been ... I have a specific login form that calls the dbLogin function as shown ... Dim strCriteria As String ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Nochmals Treeview
    ... private void button1_Click(object sender, System.EventArgs e) { ... private void TabelleAnlegen(string strDBPfad, string strDB, string strTabellenName){ ... OleDbConnection connection = new OleDbConnection; ... OleDbCommand command = new OleDbCommand; ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • Re: ExecuteReader requires an open and available Connection.
    ... you have ALL your users sharing one connection. ... Public Shared Function GetServerAs String ... Dim theServer As String ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Error using Login control ASP.NET App_Data Folder
    ... the UserInstance type of connection string is for SQLEXPRESS only and is ... Server Management Studio and use a standard connection ... An error has occurred while establishing a connection to the server. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Change Connection String during runtime
    ... connection is stored in the app.config file. ... connection string without exiting the application. ... Dim newConnection As String ... Private Sub RecordDatabase_Enter(ByVal sender As Object, ...
    (microsoft.public.dotnet.languages.vb)