If your VarChar data is less than 1500 Characters in length you can add
another column to the table setting it to type text 1500, then you can do:
Update SomeTable set Some1500TextCol = SomeVarCharCol
If Greater than 1500, but less than 4092, then change the new column to type
NOTE.
Then do your export.
If you do not wish to change the structure of your existing table, then just
Project the structure of the existing table to a temp table, then change the
VarChar column in the Temp Table to a different name, and a datatype of
either TEXT or NOTE as befits your circumstance, then you can simply do:
insert into SomeOtherTable select {Column List from SomeTable} from
SomeTable
Then do your export.
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Bo
> Franzén
> Sent: Thursday, October 09, 2014 7:30 AM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Exporting LONG VARCHAR columns to Excel or Word
>
> Hej R:BASE!
>
>
> I'm back in research using relational databases, i.e. R:BASE - great! I
> have a data base with a table containing two text columns that in some
> cases are pretty long, so I predefined them in LONG VARCHAR when I
> created the base five years ago or so. But when exporting those two
> columns from the table to Excel or Word, some of the longest text parts
> are lost (e.g. ########### in word). I've tried to make a view of the
> whole table and export from there, but the problems remain. I have not
> tried to change the two LONG VARCHAR columns into TEXT yet, but could
> that be an opportunity nowadays?
>
>
>
> Bo Franzén
> Department of Economic History
> Stockholm University
