dealing with corrupt varchar data

[Ruslan Zasukhin]

On 28/12/07 2:06 AM, "Dave Parizek" <david at parizek.com> wrote:

Hi Dave,

> I am getting an error <SQLSTATE name="99503">
> <DESCRIPTION>ERR_INTERNAL_VARCHAR_CORRUPTED</DESCRIPTION>
> <MESSAGE>Varchar data &quot;%S&quot; is corrupted.</MESSAGE> </SQLSTATE>
> 
> I know which of my tables the corruption in, and tried to use VStudio
> to just delete all data in that table, to no avail.
> 
> What does on do to fix a database with varchar corruption?

Any db can be tried to be fixed using DB.Clone().
 

> I think in RB I was able to dump it and then reload it, and that would
> fix it, and it seemed that happened often so I had to do a lot of
> dumping and reloading.
> 
> But I cannot get VStudio Mac most recent version to work half the
> time, much less do a dump and successfully reload it.

I have not catch: what problems with VStudio
 
> Is there some other way to fix or delete corrupt varchar data?  Does
> dump and reload work still typically?

Open db in vstudio
    right click on db in second column
    choose in contextual menu CLONE
   


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]