|
Home > Archive > MS SQL Server > February 2006 > Ntext replication - Max size exceeded
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Ntext replication - Max size exceeded
|
|
| Sanjay 2006-02-28, 8:23 pm |
| Hi,
I am facing one wierd problem.
I have one table having column as Ntext, from front end we are inserting
50000 characters.Replication is enabled , when we are inserting 50K
characters we are getting error
"Length of text, ntext, or image data (100000) to be replicated exceeds
configured maximum 65536.The statement has been terminated"
Is it because column is ntext and internally sql server treat this as double
byte character and try to insert 100000 characters. replication by default
supports 65536 characters...
i am bit confused on this sql behavior/
--
Sanjay
| |
| Dan Guzman 2006-02-28, 8:23 pm |
| The 'max text repl size' specifies the max size *in bytes* so you need to
double the number of characters for ntext to calculate the number of bytes.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Sanjay" <Sanjay@discussions.microsoft.com> wrote in message
news:BC35046F-BC44-4C02-8BBF- 6533BF5897AA@microso
ft.com...
> Hi,
> I am facing one wierd problem.
>
> I have one table having column as Ntext, from front end we are inserting
> 50000 characters.Replication is enabled , when we are inserting 50K
> characters we are getting error
>
> "Length of text, ntext, or image data (100000) to be replicated exceeds
> configured maximum 65536.The statement has been terminated"
>
> Is it because column is ntext and internally sql server treat this as
> double
> byte character and try to insert 100000 characters. replication by default
> supports 65536 characters...
> i am bit confused on this sql behavior/
>
>
> --
> Sanjay
|
|
|
|
|