Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2008-10-17 : 10:07:35
|
| I've set up a link from Oracle 10g to SQL SERVER 2000 via an odbc connection.The Oracle 10g is set up as a multi-byte unicode database, if that matters (and it might).Let's say I have a table in SQL Server with a varchar(20) column in it.If I query that column via the odbc link, and ask for the length of the data in the column, I'll get the correct number.However, if I query the column to get its value, only 1/2 of the column's characters come across. The others are truncated off without a warning.SQL SERVER Driver Version is 2000.86.3959.00, dated 17-Feb-2007.I've fiddled with all the check boxes in the driver settings. The dates and numbers aren't getting truncated now, but the varchar fields are.Still trying to figure out where I can find out if there is a later driver and were to download it.One can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
rammohan
Posting Yak Master
212 Posts |
Posted - 2008-10-18 : 02:51:21
|
| pls show me da solutionOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
 |
|
|
|
|
|
SQL SERVER ODBC Driver truncates character data.