Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread

 

By: Mario Ruiz
RE: charset encoding [ reply ]  
2008-10-20 16:14
I'm using dsn.

The driver is Microsoft ODBC for Oracle.

By: Erik Hollensbe
RE: charset encoding [ reply ]  
2008-10-20 16:06
No, I mean, what DBD for DBI are you using?

Sorry to draw this out :) But if you can paste the first argument of your DBI connect string (the "dbi:Oracle:database" or "dbi:OCI8:database" portion), that will suffice. And thanks for getting back to me, it's appreciated.

-Erik

By: Mario Ruiz
RE: charset encoding [ reply ]  
2008-10-20 09:48
What I'm using is Oracle 10 client, but I don't really know if the server is Oracle 10 or 9... I think is 10.

By: Erik Hollensbe
RE: charset encoding [ reply ]  
2008-10-17 17:46
Hmm....

Just for my own clarification, what DBD are you using? Reason I'm asking is the old Oracle DBD is deprecated (superceded by the OCI8 one), and if this is related to that it'll help me support future people with this problem.

By: Mario Ruiz
RE: charset encoding [ reply ]  
2008-10-17 09:50
I get it.
It was because the Oracle server language was AmericanEnglish and my oracle client was Icelandic so I changed the NLS_LANG in regedit and it's working now!

Thanks.

By: Erik Hollensbe
RE: charset encoding [ reply ]  
2008-10-16 17:38
Hi Mario,

I have two questions before I can help:

What DBD are you using? (Oracle, OCI8, etc)
What do your NLS environment variables look like when DBI connects?

Thanks,

-Erik

By: Mario Ruiz
charset encoding [ reply ]  
2008-10-16 11:42
When I insert this value: éI9Áq'ÜnPt•
on my oracle database using the website and I try to verify the value in the database using dbi, I get this other value: éI9Áq'ÜnPt¿
So the value for • in the database was changed to ¿
How could I decode this value to get the correct entry??

Thannks.