Porque as páginas que acessam o banco de dados estão exibindo caracteres estranhos ?

Para resolver problemas de acentuação com aplicações em PHP, Java e outras linguagens não-Microsoft que utilizam o SQL Server, consulte antes Resolvendo problemas de acentuação em PHP / Java e SQL Server

Isto ocorre devido ao fato da sua base de dados local utilizar um collation diferente do collation padrão da Locaweb (SQL_Latin1_General_CP850_CI_AI).

Nestes casos, é necessário que você altere o collation da sua base na Locaweb para o mesmo collation utilizado na sua base local e efetue uma nova exportação dos dados.

Para verificar qual é o collation utilizado na sua base de dados local, execute o comando sp_helpdb e verifique no campo status o item collation.

Para alterar o collation da sua base na Locaweb, basta executar as instruções abaixo.

 

 

ALTER DATABASE <nome_banco> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE <nome_banco> COLLATE <novo_collation>; ALTER DATABASE <nome_banco> SET MULTI_USER;

 

  • Como alterar o collation do campo de uma tabela.

 

ALTER TABLE <tabela> ALTER COLUMN <campo> <tipo_de_dado> COLLATE <novo_collation>;

 

  • Como verificar o collation atual da sua base.

 

SP_HELPDB <sua_base>;

Verifique na coluna Status o Collation

Em caso de dúvidas sobre qual collation utilizar verifique a Documentação Oficial

Observações:

  • Lembre-se de remover os sinais de maior (>) e menor (<).
  • A alteração de collation da base somente afeta os novos objetos criados, as tabelas já existentes permanecerão com o collation anterior.
  • Na Videobes, inicialmente, todas as bases são habilitadas usando o collation SQL_Latin1_General_CP850_CI_AI.

Esse artigo ajudou você?

100 respostas para “Collation( codificação de caracteres ) no MS SQL Server”

  1. Mary Brohl

    What’s your favorite Halloween esq music to listen to? I’d have to go with The Cramps

    Responder
  2. Georgette Loiacono

    whoah this blog is fantastic i love reading your posts. Keep up the good work! You know, many people are searching around for this information, you could aid them greatly.

    Responder
  3. look what i found 9janewswatch.com

    hi!,I like your writing very much! share we communicate more about your article on AOL? I need a specialist on this area to solve my problem. Maybe that’s you! Looking forward to see you.

    Responder
  4. recommended you read legal-news-central.com

    I used to be very pleased to search out this net-site.I needed to thanks on your time for this excellent learn!! I positively having fun with each little bit of it and I’ve you bookmarked to check out new stuff you weblog post.

    Responder
  5. Amazon Coins

    I cherished up to you will obtain performed right here. The cartoon is tasteful, your authored subject matter stylish. nevertheless, you command get bought an impatience over that you wish be handing over the following. ill certainly come more formerly once more as exactly the same just about very often inside case you defend this increase.

    Responder
  6. More Bonuses 336news.com

    This is the fitting weblog for anyone who wants to search out out about this topic. You notice a lot its almost onerous to argue with you (not that I truly would need…HaHa). You undoubtedly put a brand new spin on a subject thats been written about for years. Nice stuff, just nice!

    Responder
  7. Boris Nacol

    Pretty nice post. I just stumbled upon your blog and wanted to say that I’ve really enjoyed surfing around your blog posts. In any case I will be subscribing to your rss feed and I hope you write again soon!

    Responder
  8. Jimmie Almasi

    I am really loving the theme/design of your website. Do you ever run into any browser compatibility issues? A small number of my blog audience have complained about my site not operating correctly in Explorer but looks great in Safari. Do you have any advice to help fix this problem?

    Responder
  9. https://apnews.com/press-release/kisspr/lifestyle-nutrition-stress-medication-mental-health-66da727f167882320f97f69b1992e247

    That is a great tip particularly to those new to the blogosphere. Short but very accurate information… Many thanks for sharing this one. A must read post.

    Responder
  10. נערת ליווי

    אדריאנה צעירה סקסית בטירוף בסקס עם החבר שמפנק אותה ואז מזיין אותנה חזק
    שירותי ליווי בתל אביב

    Responder
  11. נערות ליוויl

    זו לא עוד בדיקה שגרתית אלא רופא שיודע איך לשחק עם המטופלת שלו – זה נגמר בסקס לוהט ובמציצה עמוקה
    שירותי ליווי

    Responder
  12. Ralph Giannotti

    Aw, this was quite a good post. In idea I must set up writing in this way additionally – taking time and actual effort to make a good article… but exactly what can I say… I procrastinate alot and also by no means manage to go carried out.

    Responder
  13. נערות ליוויl

    סרטון ביתי של זוג צעיר שצילמו את עצמם
    נערות ליווי במרכז

    Responder
  14. נערת ליווי

    בלונדינית מטורפת נדפקת על ידי הדוקטור על השולחן שלו, מוצצת ומקבלת זין חזק עד שהיא שוכחת למה היא באה
    נערות ליווי בתל אביב

    Responder
  15. נערות ליוויl

    דוקטור צעיר ושובב נותן למטופלת הסקסית שלו זין ענק ועמוק בשביל לבדוק מה קורה מבפנים
    שירותי ליווי

    Responder
  16. נערות ליוויl

    מיה מקבלת את המתנה הטובה ביותר לכריסמס – זיון אנאלי סוער! מתחילה במציצה ומסיימת בגמירה רטובה
    ליווי במרכז

    Responder
  17. more info here

    I do love the manner in which you have framed this specific issue and it does supply me a lot of fodder for consideration. Nevertheless, through what I have observed, I just simply trust as the actual comments pack on that men and women continue to be on point and not start upon a tirade associated with some other news du jour. All the same, thank you for this exceptional point and even though I do not really agree with it in totality, I respect your perspective.

    Responder
  18. Shayne Franzeo

    Your blog is amazing dude. i love to visit it everyday. very nice layout and content .    

    Responder
  19. cialis online

    Thanks for the sensible critique. Me & my neighbor were just preparing to do a little research on this. We got a grab a book from our local library but I think I learned more from this post. I’m very glad to see such excellent information being shared freely out there.

    Responder
  20. נערת ליווי

    בחורה שאוהבת למצוץ מוצצת עמוק מול המצלמה של החבר שלה
    נערות ליווי במרכז

    Responder
  21. ליווי בישראל

    בחור שחור עם כלי ענק מזיין בחורה שווה בסקס אנאלי לאחר שהיא מוצצת לו עמוק ורוכבת עליו
    שירותי ליווי בתל אביב

    Responder
  22. plumbing services Find Out More

    Wonderful blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thanks

    Responder
  23. 출장 안마

    Hello! I simply want to give you a big thumbs up for your great information you have got here on this post. I will be returning to your site for more soon.

    Responder
  24. reference 365planetnews.com

    Hey There. I discovered your blog the use of msn. That is a really well written article. I will make sure to bookmark it and return to read extra of your useful info. Thank you for the post. I’ll definitely return.

    Responder
  25. נערת ליווי

    צעירה יפייפיה עם משקפיים מקבלת זין עמוק מהדוקטור על מיטת הטיפולים שלו
    שירותי ליווי

    Responder
  26. game news

    I blog often and I truly appreciate your content. This great article has truly peaked my interest. I will take a note of your site and keep checking for new details about once per week. I opted in for your Feed as well.

    Responder
  27. נערת ליווי

    במועדון בגרמניה אורגיה מטורפת עם כוסיות וגברים שמזדיינים באמצע המועדון
    שירותי ליווי בתל אביב

    Responder
  28. read what he said

    Awsome website! I am loving it!! Will be back later to read some more. I am taking your feeds also.

    Responder
  29. שירותי ליווי

    בלונדינית סקסית ושווה נדפקת ברכב באמצע הדרך
    שירותי ליווי

    Responder
  30. Edwardo Svob

    Hey, have you possibly wondered to publish about Nintendo Dsi handheld?

    Responder
  31. Synapse XT USA

    I’m impressed, I have to admit. Rarely do I come across a blog that’s equally educative and interesting, and without a doubt, you have hit the nail on the head. The problem is an issue that too few people are speaking intelligently about. I’m very happy that I came across this in my search for something relating to this.

    Responder
  32. נערות ליוויl

    בלונדינית יפה מוצצת עמוק ומזדיינת עד שהיא מתעייפת – סקסית בטירוף
    נערות ליווי בתל אביב

    Responder
  33. Where Can I Get Boob Tape

    This design is wicked! You most certainly know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Fantastic job. I really loved what you had to say, and more than that, how you presented it. Too cool!

    Responder
  34. Hemp Pain Cream Maximum Strength

    I used to be more than happy to search out this web-site.I wanted to thanks on your time for this glorious read!! I positively enjoying each little bit of it and I’ve you bookmarked to take a look at new stuff you weblog post.

    Responder
  35. JBO.com

    Excellent post. I will be experiencing many of these issues as well..

    Responder
  36. DC Apartment movers

    Great write-up, I am normal visitor of one’s website, maintain up the excellent operate, and It is going to be a regular visitor for a lengthy time.

    Responder
  37. 6 hour adult drivers ed near bristol illinois

    Hello. excellent job. I did not expect this. This is a excellent story. Thanks!

    Responder
  38. Dunkin Lyss

    I really enjoyed this article. I hope you keep on create more articles.

    Responder
  39. Spencer Si

    Having read this I believed it was really informative. I appreciate you finding the time and energy to put Bandar Baccarat Online this short article together. I once again find myself spending a lot of time both reading and leaving comments

    Responder
  40. Gout Hands And Feet

    Thank you so much for giving everyone an extraordinarily memorable possiblity to read from this blog. It is often so cool and as well , stuffed with amusement for me personally and my office peers to search your website not less than 3 times weekly to learn the new tips you will have. Not to mention, I am usually contented concerning the attractive guidelines you give. Selected 4 facts in this article are rather the most efficient we have ever had.

    Responder
  41. Top Roofing Contractors Near Me

    After I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a remark is added I get four emails with the identical comment. Is there any method you may take away me from that service? Thanks!

    Responder
  42. 출장안마

    I couldn챠t resist commenting. Perfectly written!

    Responder
  43. ProstaStream Updated

    Nice post. I learn something new and challenging on websites I stumbleupon on a daily basis. It will always be interesting to read through content from other writers and use something from other sites.

    Responder
  44. Safe Anti Inflammatory For Dogs

    I discovered your weblog website on google and verify a number of of your early posts. Proceed to maintain up the very good operate. I just further up your RSS feed to my MSN News Reader. Looking for forward to studying extra from you afterward!…

    Responder
  45. dildo sex toy

    As a Newbie, I am permanently exploring online for articles that can be of assistance to me. Thank you

    Responder
  46. sexy plus lingerie

    Heya i am for the first time here. I found this board and I find It truly useful & it helped me out much. I’m hoping to give one thing back and help others like you aided me.

    Responder
  47. Holdups

    Yesterday, while I was at work, my cousin stole my iphone and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is totally off topic but I had to share it with someone!

    Responder
  48. SamuelChorp

    מילפית עם ציצי ענק וכוס מושלם נדפקת על הספה בכל התנוחות האפשרויות
    https://www.israelxclub.co.il/נערות-ליווי-בראשון-לציון/

    Responder
  49. ליווי בישראל

    אמא סקסית בטירוף מוצצת ונדפקת מול המצלמה
    שירותי ליווי בתל אביב

    Responder
  50. Skincell Pro Review

    Great info. Lucky me I discovered your website by chance (stumbleupon). I’ve saved as a favorite for later!

    Responder
  51. עיסוי אירוטי

    אחות חורגת בלונדינית כוסית נדפקת על ידי האח החורג במיטה שלו
    נערות ליווי בחיפה

    Responder
  52. online learning

    Thank you, I have recently been looking for info about this topic for ages and yours is the greatest I have discovered so far. But, what about the conclusion? Are you sure about the source?

    Responder
  53. Autoflowering Snack Cannabis Seed Mixpack

    Great article! We will be linking to this great article on our site. Keep up the good writing.

    Responder
  54. Side Sleeper Hip Pain

    Superb blog you have here but I was wanting to know if you knew of any discussion boards that cover the same topics talked about in this article? I’d really love to be a part of group where I can get feedback from other experienced people that share the same interest. If you have any suggestions, please let me know. Thanks!

    Responder
  55. Jessica Wengler

    Having read this I believed it was rather enlightening. I appreciate you finding the time and energy to put atlantis story this short article together. I once again find myself personally spending a lot of time both reading and commenting

    Responder
  56. שירותי ליווי

    נערות ליווי בצפון אתר סופר חזק אני מאוד ממליץ על פורטל הזה באמת יש אחלה מידע בנות סופר יפות

    Responder
  57. free horror

    You’re so cool! I don’t believe I’ve read a single thing like that before. So good to discover another person with some genuine thoughts on this issue. Really.. many thanks for starting this up. This site is one thing that is required on the web, someone with a bit of originality.

    Responder
  58. Leland Morado

    I regard something truly special in this website .

    Responder
  59. Look At This legal news central

    Great post. I used to be checking continuously this weblog and I am impressed! Extremely useful info specifically the final phase 🙂 I handle such information much. I used to be looking for this particular information for a long time. Thank you and best of luck.

    Responder
  60. Keesha Brening

    Perfect work you have done, this site is really cool with excellent information.

    Responder
  61. original site

    I simply want to tell you that I am just beginner to blogs and honestly enjoyed your page. Very likely I’m likely to bookmark your blog . You amazingly have very good articles and reviews. Thanks for sharing with us your web page.

    Responder
  62. made in usa positioning hinges

    Fascinating blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your theme. With thanks

    Responder
  63. hicbdbye cbd for dogs

    I really appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thank you again! buy cbd oil pure cbd for sale

    Responder
  64. hipaydaybye payday loan

    I just like the helpful information you provide on your
    articles. I will bookmark your blog and test again here regularly.
    I’m somewhat sure I’ll be told many new stuff right here!
    Best of luck for the following! hipaydaybye lender hipaydaybye loan online

    Responder
  65. Pretty Gaming

    Saved as a favorite, I really like your website!

    Responder
  66. Berna Naimoli

    בימים אלו הגברים עלולים לסבול מהרבה מאוד מתחים אשר גובים מהם מחיר אישי כבד. משבר הקורונה, המצב הביטחוני, המצב הכלכלי או ההתחממות הגלובלית. הכל מצטבר ביחד ויוצר לחץ מטורף אשר פוגע באיכות החיים שלכם. רוצים לדעת מהי הדרך הכי טובה והכי מהירה לצאת מהלחץ? בילוי עם נערות ליווי הוא הפתרון הטוב ביותר. בילוי שכזה הוא בילוי ללא דאגות. ניתן לקיים את הבילוי בדירות דיסקרטיות ושם תהיו חופשיים להתמסר לבילוי. האמת שאתם לא צריכים לעשות כלום, רק להתמסר לידיה של נערה חיננית וחטובה, לפי בחירתכם, אשר תשתמש בידיה ובגופה על מנת להעניק לכם עיסוי עמוק ומרגיע. עיסוי אשר יגרום לכם לשחרר ולהרפות.

    Responder
  67. Shayne Blazing

    Spot lets start on this write-up, I actually believe this site wants far more consideration. I’ll probably be once again you just read far more, many thanks that information.

    Responder
  68. Last mile delivery

    F*ckin’ amazing things here. I’m very glad to see your article. Thanks so much and i am taking a look forward to touch you. Will you kindly drop me a mail?

    Responder
  69. why not look here

    I like the helpful info you provide in your articles. I will bookmark your weblog and check again here regularly. I’m quite certain I will learn lots of new stuff right here! Best of luck for the next!

    Responder
  70. Benedict Keesee

    Hello there, I found your site via Google while looking for a comparable matter, your website came up, it seems to be great. I have bookmarked it in my google bookmarks.

    Responder
  71. Maud Loverich

    we love watching Dancing with the stars, the actresses and actors that joins it are nice-

    Responder
  72. 스포츠 북

    Best view i have ever seen !

    Responder
  73. Ergon for sale

    F*ckin’ tremendous things here. I am very satisfied to look your article. Thanks a lot and i’m looking forward to touch you. Will you kindly drop me a e-mail?

    Responder
  74. Snapchat Usernames

    You are a great writer thanx. I love sucking dick btw hmu

    Responder
  75. Relief From Gout In Feet

    It’s perfect time to make a few plans for the longer term and it’s time to be happy. I’ve learn this submit and if I could I desire to counsel you few interesting issues or advice. Perhaps you could write next articles referring to this article. I desire to learn even more things approximately it!

    Responder
  76. 출장마사지

    Good day! I could have sworn Iíve been to this web site before but after looking at some of the articles I realized itís new to me. Nonetheless, Iím definitely happy I stumbled upon it and Iíll be bookmarking it and checking back frequently!

    Responder
  77. plumber go to the website

    I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an impatience over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly very often inside case you shield this increase.

    Responder
  78. plumbing companies why not try these out

    Hello there! I know this is kinda off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!

    Responder
  79. home warranty company reviews

    Hello to every one, since I am genuinely keen of
    reading this website’s post to be updated regularly.
    It carries nice data.

    Responder
  80. VitalFlow Updated

    I blog often and I truly thank you for your information. This great article has really peaked my interest. I am going to take a note of your website and keep checking for new details about once a week. I subscribed to your RSS feed too.

    Responder
  81. underpinning foundation cost

    Thanks for ones marvelous posting! I truly enjoyed reading it, you can be a great author.I will be sure to bookmark your blog and definitely will come back sometime soon. I want to encourage you to ultimately continue your great work, have a nice holiday weekend!

    Responder
  82. 마사지알바

    At this particular price, you can premiere as a copy writer. I am so touched. I am just cheerful to meet you. Say thanks to you.

    Responder
  83. 슬롯

    Best view i have ever seen !

    Responder
  84. super home warranty

    Howdy! I could have sworn I’ve been to this blog before buut after browsing
    throug some of the post I realized it’s new to me.
    Nonetheless, I’m definitely delighted I found it annd I’ll
    be bookmarking and checking back frequently!

    Responder
  85. White glove delivery

    naturally like your web site however you need to test the spelling on several of your posts. Several of them are rife with spelling issues and I in finding it very bothersome to inform the reality then again I’ll certainly come again again.

    Responder
  86. נערות ליווי

    עם גרביונים ורודים וגוף פצצה הבלונדינית הזו נותנת זיון שאי אפשר לשכוח
    נערות ליווי באילת

    Responder
  87. cool home improvement ideas

    Hey! This post couldn’t be written any better! Reading through this post reminds me of my old room mate! He always kept talking about this. I will forward this page to him. Fairly certain he will have a good read. Thanks for sharing!

    Responder
  88. Bariatric Vitamins Patches

    Hey are using WordPress for your blog platform? I’m new to the blog world but I’m trying to get started and create my own. Do you need any coding expertise to make your own blog? Any help would be greatly appreciated!

    Responder
  89. Pool table refelting

    Wonderful web site. Plenty of useful info here. I am sending it to several friends ans also sharing in delicious. And of course, thank you for your sweat!

    Responder
  90. White glove delivery

    Great amazing things here. I¡¦m very glad to look your article. Thanks a lot and i am taking a look forward to contact you. Will you kindly drop me a e-mail?

    Responder
  91. check this site out

    I just want to tell you that I am just new to blogging and site-building and seriously liked this web blog. Almost certainly I’m planning to bookmark your blog . You surely have incredible posts. Cheers for revealing your website page.

    Responder
  92. q significa marketing digital

    This is the precise blog for anybody who desires to seek out out about this topic. You notice a lot its nearly arduous to argue with you (not that I really would need…HaHa). You positively put a brand new spin on a subject thats been written about for years. Great stuff, simply nice!

    Responder
  93. my blog

    Good web site! I really love how it is simple on my eyes and the data are well written. I’m wondering how I might be notified whenever a new post has been made. I’ve subscribed to your feed which must do the trick! Have a great day!

    Responder
  94. roadside assistance

    Somebody essentially help to make severely posts I would state. That is the first time I frequented your web page and to this point? I amazed with the research you made to create this particular publish extraordinary. Wonderful activity!

    Responder
  95. her comment is here

    As I web site possessor I believe the content material here is rattling wonderful , appreciate it for your hard work. You should keep it up forever! Best of luck.

    Responder
  96. Corie Dechico

    I simply want to mention I am newbie to blogging and really enjoyed you’re web blog. More than likely I’m planning to bookmark your website . You surely have really good article content. Cheers for sharing with us your web-site.

    Responder

Comente sobre este conteúdo! Escreva o que pensa, complemente, vamos discutir. O conhecimento é livre!