September 10, 2012 at 9:45 am
I have a database with transactional replication, more or less 15 days replicated table does not recognize stress, obs. the collation remains Latin_General_850_CI_AS in the publisher table he recognizes words with accents.
Can anyone help me with this item.
Thank you,
Robson Vieira
Brazil
September 10, 2012 at 12:21 pm
What do you mean by "recognizes accents"? "Recognizes" is an ambiguous non-technical term that does not tell us what is really going on.
Describe to use what commands/actions you are doing and what results you are receiving that are leading you to this conclusion.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2012 at 5:19 am
Sorry, but my English is bad, the result of the selection of the published table:
força na disputa por participação de mercado. A aérea
Result of the selection of the subscription table:
for+a na disputa por participa+Æo de mercado. A ÿa'rea
This started happening 15 days collations are the same publisher and subscription, replication is smooth and synchronized, and I have no idea what they might be.
September 11, 2012 at 7:27 am
First, use Management Studio to generate a script of both the published table and the subscription table. Make sure that you have the "Include Collation" scripting option turned on (its in Tools..Options.., SqlServer Object Explorer+Scripting). Post those scripts here, indicating which columns are showing this problem.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2012 at 7:48 am
After thinking about it some, I suspect that this is probably a codepage problem...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply