rails & sqlserver collation problems

rubyonrails-talk
1

Boa tarde pessoal.

Estou utilizando o intant rails com ruby v.1.8.6 e rails 2.0.2 com um servidor sqlserver2000, minha base de dados usa o collation SQL_latin1_general_CP1_CI_AS, quando tragos strings com acentuação e cedilha não consigo visualizar os carateres corretos, sei que para exibir corretamente o texto no ruby tenho que usar UTF-8. Como posso fazer pra mudar o collation da minha base ou converter as string para UTF-8 na hora de exibir?

Desde já agradeço Eduardo

2

Peço desculpas pelo meu Português. Estou usando o Google Translate. :slight_smile:

Você precisa informar o arquivo database.yml que pretende conversar com o banco de dados em UTF-8. Para fazer isso adicione encoding: utf8 para o seu banco de dados no database.yml. Deixe-me saber como isso vai.

Obrigado, B.

3

Por favor, pare top postagem

4

http://en.wikipedia.org/wiki/Posting_style “The traditional style was for a long time to post the answer below as much of the quoted original as was necessary to understand the reply (bottom or inline). Many years later, when email became widespread in business communication, it however became a widespread policy to reply above the entire original and leave it untouched (and without any prefixes at the beginning of each line) below the reply.”

5

Q: Why is top-posting such a bad thing? Q: What is the most annoying thing in e-mail?

Por favor, pare top postagem

"The traditional style was for a long time to post the answer below as much of the quoted original as was necessary to understand the reply (bottom or inline). Many years later, when email became widespread in business communication, it however became a widespread policy to reply above the entire original and leave it untouched (and without any prefixes at the beginning of each line) below the reply."

This list isn't a business communication - it's a reference resource, and that "policy" was imposed because one company's email software that just "did it that way" - irregardless of any user preference.

Posting style - Wikipedia

Read the whole of that article... especially the section on "Choosing the proper posting style". If after that you still insist on top-posting, so be it :-/ *shrug*

6

I reply to the email that I receive which uses the standard method of top posting. Why? Because if you bottom-posted all the time or unnecessarily inline quoted it would make this thread: http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/6c25db52c2d743aa and others like it unreadable.

I’m done discussing posting styles. Let’s return to helping each other out which is the main reason for this group.

7

I reply to the email that I receive which uses the standard method of top posting.

What "standard"? Which RFC says that there is any "standard"?

if you .... unnecessarily inline quoted it would make this thread: http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/6c25db52c2d743aa and others like it unreadable.

no... top-posting makes it impossible to maintain a coherent conversation, and introduces confusion about what replies refer to, because there's no context.

I'm done discussing posting styles.

So I guess you *didn't* bother reading the rest of the article you waved as defence of your position? ... hence my *shrug*

PS You've got a frightfully annoying email client too, which sends *to* the person, and CCs the group - so further replies go to you, not the group... :-/

8

Eu tentei usar o encoding: utf8 no database.yml, mas para o sql server não funciona. tentei então um helper para a classe string com o seguinte código

-----------------------------------------------------------code starts here-----------------------------------------------------------------------

class String   # Returns a valid DateTime object if the object can be converted according to +format+, nil otherwise.   # FIXME: Corrigir o erro de validação em colunas contendo data + hora.

  gem 'chardet'   require 'UniversalDetector'

  def parse_date(format = ActiveSupport::CoreExtensions::date::Conversions::DATE_FORMATS[:default])     begin       DateTime.strptime(self, format)     rescue ArgumentError     end   end

  def to_utf8      @encode_type = UniversalDetector::chardet(self)["encoding"] #detects the str encoding      Iconv.iconv("UTF-8", @encode_type, self).to_s #converts the current encoding to UTF-8 of the present string   end

end

-----------------------------------------------------------code ends here-----------------------------------------------------------------------

O chardet é uma gem que pode retornar o tipo de codificação utilizada na string, o tipo de codificação retornado para o SQL_latin1_genreal_CP1_CI_AS é o ISO-8859-5 e o iconv consegue passar a string para utf8, porém os resultados ainda não são satisfatórios pois os caracteres acentuados e as cedilhas não são exibidos corretamente. Veja abaixo:

O que deveria exibir:

Fundação Ecumênica de Proteção ao Excepcional - PARANC

está exibindo:

Fundaчуo Ecumъnica de Proteчуo ao Excepcional - PARANС

Sinto que estou chegando perto, alguém sabe como prosseguir deste ponto?

Desde já agradeço Edu