On Tue, 2004-02-10 at 02:49, [EMAIL PROTECTED] wrote: > > > i am accessing an oracle database from redhat linux. oracle version 8.1.7 > when i execute a query against the data that contains the swedish character > Ã i get a ? returned instead. i've run some test in perl and oracle. in > oracle the character mentioned is ascii 229. perl has no problem with the > character. it prints the correct character. but when i uses DBI to > connect to the database and retrieve the character it gets translated to > ?.
This is not an linux or windows issue. This is a character set issue between the oracle database and the oracle client. I have been do some work trying to get Unicode working in DBD-Oracle.... and it turns out that there several different ways you can setup an oracle instance, and your interaction with it on the client side. This will have information that should help you understand this: http://www.csee.umbc.edu/help/oracle8/server.815/a67789/toc.htm You would do even better by looking for 817 docs. But I think this will contain an explanation of what is happening to you. Lincoln
