Bugs: Browse | Submit New | Admin

[#5723] Upgrading from oci8 1.1.13 (ruby 1.8.2) to oci8 1.1.15 (ruby 1.8.4), NLS_LANG problem.

Date:
2006-09-11 15:30
Priority:
3
Submitted By:
Mathieu Chappuis (mollo)
Assigned To:
Nobody (None)
Category:
None
State:
Open
Summary:
Upgrading from oci8 1.1.13 (ruby 1.8.2) to oci8 1.1.15 (ruby 1.8.4), NLS_LANG problem.

Detailed description
Dear,

Win XP
Oracle 8.1.7

I actually test upgrading an existing Rails application from

(old setup)

Ruby 1.8.2
RubyOCI8 1.1.13
Rails 1.0

to (new setup)

Ruby 1.8.4
RubyOCI8 1.1.15 (same issue on 1.1.16)
Rails 1.1.6

---------

Actually I use a system fixed NLS_LANG (say ISOxxx) and into my Rails Apps I swith to UTF-8 using
ENV['NLS_LANG']=FRENCH_FRANCE.UTF8

That don't work in the new setup. Only the primary NLS_LANG is taken. (ISOxxx)

For excluding Rails from this issue, I've tried to upgrade my old setup with last RubyOCI (1.1.16) and I got the same
results :

Changing ENV don't have effect, the primary NLS_LANG is still used.

I shaw some notes about SET in changelog..but that don't teach me.

Thanks for your work.





Add A Comment: Notepad

Please login


Followup

Message
Date: 2006-09-18 05:14
Sender: Kubo Takehiro

> But rails runs "require 'oci8'" before processing
config/environment.rb :-<

No. "require 'oci8'" is done on Rails::Initializer.run
in config/environment.rb.
So adding ENV['NLS_LANG'] before Rails::Initializer.run will
works.
Date: 2006-09-18 04:43
Sender: Kubo Takehiro

Add ENV['NLS_LANG']='FRENCH_FRANCE.UTF8' to config/boot.rb on
rails.

On ruby-oci8 0.1.13, NLS_LANG is used when the first logon.
On 0.1.15 and 0.1.16, when "require 'oci8'".
I think this difference causes no change on most applications.
But rails runs "require 'oci8'" before processing
config/environment.rb :-<

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

No Changes Have Been Made to This Item