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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-23 : 08:38:55
|
| fernando writes "im connecting to sql servervia ms sql server odbc driver oledb provider for odbcADO 2.6my problem is :when i try to insert/update a char or varchar column which length is > 255 no errors are reported, but whene i query the table this column has only the first 255 charactersthe column is defined as varchar(2000)what do i need to do, in order to properly insert/update this type of column ??thanks." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-23 : 08:54:20
|
| Do you query it with Query Analyzer? By default it truncates all fields to 255 characters for display purposes. Go to Tools\Options\ menu, select Results tab, and change Max Chars per Column setting to see all your data.-------------------If trainstation is a place where train stops, what's a workstation? |
 |
|
|
|
|
|
insert/update (var)char columns (len>255)