Unable to import (é, è, à, ä) from oracle view

12 views
Skip to first unread message

kazimier...@infopark.de

unread,
Jul 3, 2018, 5:31:38 AM7/3/18
to Oracle enhanced adapter for ActiveRecord
Hi,

I'm working on the project where I'm loading part of the data from oracle view. When I connect to the view from Rails application I got results stripped out from 
`é, è, à, ä`
to 
`e, e,a, a`
my_orcale_db:
  adapter
: oracle_enhanced
  host
: localhost
  port
: 1521
  database
: xe
  username
: user
  password
: password

 My class to create a connection:
class UserImport < ActiveRecord::Base
  establish_connection CONNECTION
 
self.table_name = 'USER_VIEW'
end



Expected:
> UserImport.where(ref: 1197185).first.title
=> "département"

Actual:
Expected:
> UserImport.where(ref: 1197185).first.title
=> "departement"



Lori Olson

unread,
Jul 3, 2018, 10:00:58 AM7/3/18
to oracle-...@googlegroups.com
This is probably related.
https://stackoverflow.com/questions/8986359/ruby-on-rails-oracle-encoding

Sent from my iPad

Sent from my iPad
--
You received this message because you are subscribed to the Google Groups "Oracle enhanced adapter for ActiveRecord" group.
To unsubscribe from this group and stop receiving emails from it, send an email to oracle-enhanc...@googlegroups.com.
To post to this group, send email to oracle-...@googlegroups.com.
Visit this group at https://groups.google.com/group/oracle-enhanced.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages