You should never have any data loss! What you are seeing should not happen.

Can you show us the exact SQL that you used in your example - the dbinit command line, the create table, inserts, creating the proxy tables, and finally the select statement. This will help us/others see exactly what you are doing. Also please describe where the two databases reside (two different computers, same lan or across a wan?) and the connection string(s) used.

The server was started using dbsrv12.exe -x tcpip <db_filename> from Sybase Central. The Target and Remote database servers are on the same machine.

The source table creation SQL in the Remote Server is 1. create table test (col1 nvarchar(1024), col2 nvarchar(1024), col3 nvarchar(1024), col4 nvarchar(1024), col5 nvarchar(1024));

1. insert into test (col1,col2,col3,col4,col5) select repeat('a',1024), repeat('a',1023), repeat('a',1023), repeat('a',1024), repeat('a',1023); (repeat and vary for other rows)

The Proxy Table creation SQL in the Target DB is

1. CREATE server "remote_test" class 'saodbc' using 'DRIVER=SQL Anywhere Native;Server=testsrv2'; (passwords are the same of course)

2. create existing table test_et at 'remote_test...test';

3. select * from test_et

Column 1 and column 4 were blank in the proxy table select.

I hope this is sufficient.

Mark, Just want to add that I appreciate your quick response to my initial query. Don't want to seem ungrateful. :)

Mark,

Realised I hadn't answered your dbinit question. I use a standard database template so haven't got that, below is some of the output from sa_db_properties (the next best thing)

cheers...

PropName    Value
AccentSensitive Off
AuditingTypes   all
Authenticated   Yes
BlankPadding    On
CaseSensitive   Off
CatalogCollation    UCA
CharSet UTF-8
Checksum    On
Collation   UCA
ConnsDisabled   Off
DatabaseCleaner On
Encryption  None
EncryptionScope None
HasCollationTailoring   Off
HasEndianSwapFix    On
HasNCHARLegacyCollationFix  On
HasTornWriteFix Off
IQStore Off
MultiByteCharSet    On
NcharCharSet    UTF-8
NcharCollation  UCA
PageSize    8192
ProcedureProfiling  Off
ReadOnly    Off
SnapshotIsolationState  Off
SynchronizationSchemaChangeActive   Off
WriteChecksum   On

FYI: I have reproduced a problem similar to yours (but not exactly) and will investigate further.